SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.


The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Comments

Leave a comment on the original post [voiceofthedba.com, opens in a new window]

Loading comments...