MySQL

MySQL

• How to upgrade from 5.0 to 5.5 without going through 5.1 http://bitwise.blogspot.com/2010/12/upgrading-mysql-50-to-55-with-mysqldump.html
• Test upgrade incompatibilities in table definitions http://dev.mysql.com/doc/refman/5.0/en/mysqldump-upgrade-testing.html

• Upgrade 5.0 to 5.5 http://serverfault.com/questions/338419/mysql-upgrade-from-5-0-to-5-5

---

Upgrade steps:

1. Primary Server
1. Backup mysql database
2. Backup remaining databases
2. Secondary Server
1. Transfer backups created in steps 1.A. and 1.B.
2. Restore mysql
3. execute “flush privileges”
4. Upgrade MySQL
   execute “alter table proc modify column comment text”
5. Restore remaining databases
6. Make sure that upgraded MySQL behaves well
7. Backup mysql
3. Primary Server
1. Transfer backup created in step 2.G.
2. Upgrade MySQL
3. Restore mysql from backup created in step 2.G.
4. execute “flush privileges”
5. Restore remaining databases
6. Make sure that upgraded MySQL behaves well