I have MySQL 5.0 and 5.5 servers (but not a 5.1 server). The 5.0 server is myisam only, the 5.5 default is innodb. I need to move a database from the 5.0 server to the 5.5 server. The database is not big, the dump is about 32M. Both servers are Linux.
I ran a test by importing the 5.0 database into the 5.5 (after editing dumpfile from MYISAM to INNODB) server and then diffing mysqldumps from both servers. If I use --order-by-primay for the dump, the diffs are only what I would expect (version, engine, dump time, etc).
Any gotchas that I am missing? Can I import a myisam 5.0 database into a 5.5 innodb server without bad surprises?