The current version of mysql I have on my server is 5.0.67. I would like to upgrade to the latest version. Based on what I have read here: https://dev.mysql.com/doc/refman/5.5/en/upgrading.html, this is my plan:
- Kill connections to database (stop Apache, etc)
- Create backup of current databases (including mysql database) and log files
-
Upgrade 1 release at a time (5.0.67 -> 5.7.10)
- Upgrade to latest 5.0.x – 5.0.96
- Upgrade to 5.1.x
- Upgrade to 5.5.x
- Upgrade to 5.6.x
- Upgrade to 5.7.x
4.Logical or in-place upgrade?
I'm not sure what option I should choose here, what really the differences are, etc?
Right now, the source RPM installed is: mysql-5.0.67-12.15.src.rpm, when I go to http://downloads.mysql.com/archives/community/, I'm not sure what I would need to download. Or can this be updated through the command line? I'm using SuSE Enterprise Linux 11.
EDIT:
Here are my updated steps:
1. Upgrade to 5.1.x (mysqldump)
i. Dump all databases/schemas using mysqldump
ii. Shutdown MySQL Server
iii. Initialize a new MySQL 5.1.x server instance
iv. Load the dump file into new MySQL 5.1.x server
v. Run mysql_upgrade
vi. Load help tables
vii. Run mysqlcheck for status on all tables
2. Upgrade to 5.5.x (in-place upgrade) (repeat steps for 5.6.x and 5.7.x)
i. Shutdown MySQL server
ii. Back up MySQL server
iii. Change directory to new server version
iv. Start MySQL server
v. Run mysql_upgrade
vi. Load help tables
vii. Shut down/restart MySQL server
viii. Run mysqlcheck for status on all tables
Am I missing anything?
Best Answer
There are two blogs written about upgrading to 5.6/5.7 from 5.0 here: http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/ http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-7-using-an-in-place-upgrade/
My suggestion would be:
mysql_upgradein between upgrades.