I have a few schemas, Which are included in mysql 4 instance, And i want to move them to other mysql instance which running under a newer version – mysql 5.6. This instance is already including some schemas.
I want to move these schemas from the old version to the new version, And so to get rid of the old mysql instance.
What is the best practice to do so? Do i need to upgrade each version (4–>5.0, 5.0–>5.1, etc), And only after the schemas will be updated to version 5.6 i will be able to move them to the new instance?
I don't have any experience with mysql upgrading, So any tip would be great.
Best Answer
You should be able to just mysqldump the individual databases and load them straight into a MySQL instance running on the latest version. I have recommended this before:
May 26, 2015: mysql upgrading from 5.1 --> 5.6 do I have to do mysqldump before upgrade?Oct 17, 2014: Any known issues upgrading from MySQL 5.1.73 to 5.6.21?Apr 18, 2013: Steps to upgrade MySQL from version 5.0 to version 5.5Apr 11, 2013: MySQL upgrade 5.0.88 to latestWhen doing this, please do not move the grants by dumping the mysql schema. The number of columns have changes between versions :
Oct 10, 2014: MySQL service stops after trying to grant privileges to a userJun 13, 2012: Fastest way to move a database from one server to anotherTry to extracts the grants with pt-show-grants or emulate it as suggested