So I have a database created under MySQL Community Edition 5.0, and just recently found out that MySQL 5.0 will not launch under Windows 7 64-bit, but has no problems with Windows 7 32-bit. I want to migrate the database to the latest MySQL 5.6 which supports running under 64-bit OS, and through my search on Google before hand I found that its not a simple upgrade from 5.0 to 5.6, but of which I will have to migrate the database forwards to 5.1, then 5.5, then 5.6.
Has anyone gone through this process to warn me before hand of any details I need to know before migrating the database forward? In the past I have simply performed a MySQL dump command at command shell of MySQL prompt and dumped a copy of the database which can later be imported back if needed. But this was sticking with the same version of MySQL.
Before going through this process I will be making a backup of the database to not have to worry about trashing my only copy etc. This will be done on the old build which is 32-bit Windows 7in which the MySQL 5.0 service ran with no problems on prior. Then I will have to upgrade from 5.0 to 5.1 on this 32-bit old build and then import it and verify that it migrated to 5.1 without any problems.
When it comes to MySQL as a stand alone local database I wasnt concerned over upgrading it from 5.0 to 5.1 and so on because it worked flawless under 32-bit OS, and it wasnt until the recent introduction of Windows 7 64-bit that I found that MySQL 5.0 will not run under 64-bit even when trying to run it in XP Mode etc.
So before jumping into this I figured I'd check here to see if anyone has gone through a database migration like this one from 5.0 to a more modern version and any special commands that I need to execute at the MySQL prompt to pepare the data for 5.1 etc or a later version so its not say a legacy dump file that cant be imported etc?
There is plenty of info at the links here below, but figured that maybe someone here may have helpful info to add that may not be listed, as for it wouldnt be the first time I went through a migration from old to new and found out after the fact that I could have saved myself from troubles by running it past others who say... "Oh, last time I went through this, process select manual options and select a checkmark in a list prior to moving forward vs going with default settings", and later finding out that I now need to either uninstall and reinstall or perform a registry edit to enable or disable something.
5.6
http://dev.mysql.com/doc/refman/5.6/en/faqs-migration.html5.5
http://dev.mysql.com/doc/refman/5.5/en/faqs-migration.html5.1
http://dev.mysql.com/doc/refman/5.1/en/faqs-migration.html5.0
http://dev.mysql.com/doc/refman/5.0/en/faqs-migration.html*Also looking for a 64-bit version of MySQL 5.0 it appears that the oldest available at mysql.com is 5.1, yet there are some other hits on Google from lesser trusted sources that I havent checked out yet which may offer MySQL 5.0 64-bit as seen here:
https://www.google.com/#q=mysql+5.0+64-bit which might be the easiest way to make it run under Windows 7 64-bit, but of which I would rather get the download from a trusted source vs a Google hit from potentially shady source. Then of which there are 6 rev versions of 5.0 as:
5.0.4
5.0.41
5.0.51
5.0.67
5.0.95
5.0.96
And of which it would be best to run the latest of the obsolete version 5.0.96 but of which will I run into problems importing from an earlier Rev to a later Rev of the same version 5.0 if I went this route? ( I will have to boot up the old build to see exactly what Rev of MySQL 5.0 the database is running on. )
Its too bad there is no migration tool that is free to assist with this very manual migration that I see before me..LOL