Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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

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
add comment

Your Answer

 
discard

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.