Migrating MySQL Databases

A little out of my area, but I need to move the tsqltuesday.com database to a new service. The company running the db decided that they don’t want to keep a lower level consumer type tier. Since their minimum plan is now $20/month, I decided to look elsewhere. My first move was to try Azure Database for MySQL. This is a quick look at moving the MySQL data.

I have MySQL Workbench, so I started that up. I saw a note that this contained a migration wizard. I first created a MySQL database in Azure, which is really simple. Then I created two connections from MySQL Workbench. One to the existing database and one to my new one.

2018-02-08 13_50_54-MySQL Workbench

The next step was to start the Migration Wizard. This is under the Database menu.

2018-02-08 13_51_07-MySQL Workbench

As with all wizards, this opens with a welcome page.  I clicked Start Migration to get going.

2018-02-08 13_51_24-Why GDPR Will Fast Track the Fourth Industrial Revolution _ HuffPost

The wizard is fairly simple. Once I had this working, I walked through the wizard, choosing my source and destination. This was a simple process and things connected up once I’d opened the firewall.

2018-02-08 13_51_58-MySQL Workbench

After verifying connections, I selected everything. Since this is a WordPress site, it’s a fairly small schema and set of objects.

2018-02-08 13_52_21-MySQL Workbench

I basically clicked next, next, and let everything transfer. This only took about 5 minutes.

2018-02-08 13_52_40-MySQL Workbench

Once this was done, I queried the database, and everything was working. I saw my data and it appeared complete. No errors, so I assumed things were correct. Row counts seemed to verify this.

2018-02-08 13_55_58-MySQL Workbench

This was pretty simple, perhaps even easier than using SSIS and the Copy Database Task since this was built in.

Now to figure out how to re-point the application.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.