Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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)

share|improve this question

In many cases binary upgrade will work, however in some cases dump and reload is necessary. Here listed some cases:

share|improve this answer
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. – John Gardeniers Aug 8 '12 at 13:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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