Upgrading MySQL 5.1->5.5, all InnoDB, 500GB data, linux.

To rebuild the tables/indexes for 5.5, I can either dump and load everything, or run ALTER TABLE t1 ENGINE=innodb on every table (see MySQL docs).

MySQL recommends the dump and load method here (second paragraph) as does Percona here.

I completely understand the necessity of a good backup, but I will have a clean and reliable storage snapshot serving that purpose. Also, dump/load takes much much longer and requires extra disk space and I/Os.

Is there any other good reason to prefer the dump/load method?

(same question as this one, but dealing with a much larger dataset and existing backup: MySQL Upgrade Method)

1 Answer 1


In many cases binary upgrade will work, however in some cases dump and reload is necessary. Here listed some cases: http://dev.mysql.com/doc/refman/5.1/en/checking-table-incompatibilities.html

  • That doesn't answer the question that was asked. The poster wants to know which method to use, because he/she already knows that it's required in this instance. Aug 8, 2012 at 13:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.