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).
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)