Bird migration image from: http://audubonoffloridanews.org/?p=3314

I searched far and wide and could not find a way to easily migrate MySQL data from one server to another. I remember a few years back that MySQL released a migration assistant that did the job pretty well, but that software seems have reached EOL. I had to move files on my local (windows) dev server to a new desktop that I purchased and decided to write a couple bat files that automate the process of exporting and importing the databases. Download the scripts now.

It seems that MySQL has replaced the former helpful software with MySQL Workbench — which is pretty cool, but unfortunately it doesn’t include any help for migration.

A future release of MySQL Workbench (post 5.2) will add a migration plugin, providing features comparable to the MySQL Migration Toolkit component of the MySQL GUI Tools Bundle. We will also be adding many other enhancements and new features.

Where does that leave us? Mysqldump.

I modified a MySQL backup shell script from Sonia Hamilton, and these scripts could both be modified to work with nix, but they are mainly for Windows. Read on for how to migrate your windows MySQL server.
» Read more: Backup/Migrate MySQL Databases to New Server (Windows)