I will be upgrading a large database (9GB) from MySQL 4.1 to MySQL 5.1. I have 2 options (that I know of). Which is the better option and why?
- Dump entire DB using mysqldump, upgrade the server, then import the mysqldump file. This ensures that the tables are in the new 5.1 format.
- Use the same table files on the new server, but update them using "REPAIR TABLE" command. Not sure about this method's reliability.
All tables are MyISAM.