Migrate database from MySQL 5.5 to 5.6
Posted by: Jeff Golden
Date: April 07, 2019 05:09AM

Hi everybody.

I have, please, a MySQL database that I need to convert from version 5.5 to 5.6; it's the database of my Wordpress site that I'm transferring from my old hosting provider that have MySQL 5.5 to a new one that requires MySQL 5.6.

So, I downloaded this database on my computer, installed both versions of MySQL server 5.5 and 5.6, and I'm trying to use MySQL Workbench to convert/migrate it.
I tried the "Schema Transfer Wizard" and the "Migration Wizard" but don't know how to use them; sorry I'm very beginner.

For example in the "Schema Transfer Wizard", when I select the source and destination MySQL server and click on Next, I find just a "Test" schema in the "Schema Selection" phase. How can I get my local database showed there to select it?

Could you please help me; I'm really stuck!
Thank you very much.

Options: ReplyQuote


Subject
Written By
Posted
Migrate database from MySQL 5.5 to 5.6
April 07, 2019 05:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.