10.6 MySQL migration

Perform MySQL server version upgrades to move off older MySQL versions to the latest version. The standard migration wizard can migrate MySQL to MySQL, and a simpler Schema Transfer Wizard can also be used.

MySQL Schema Transfer Wizard

The MySQL Schema Transfer wizard helps you move your data from an older MySQL server version to a different (typically later) MySQL version. This migration tool is meant for developer hosts as it is simpler than the standard migration wizard, because it only migrates MySQL to MySQL. The data is transferred and not based on a consistent snapshot, so it works best on local MySQL instances.

Note

You should not use this wizard on production MySQL instances.

To open the wizard, select Database, Schema Transfer Wizard from the main menu.

Figure 10.22 MySQL Schema Transfer Wizard: Overview

MySQL Schema Transfer Wizard: Overview

Read the overview text and click Start the Wizard to begin.

Figure 10.23 MySQL Schema Transfer Wizard: Connection Selection

MySQL Schema Transfer Wizard: Connection Selection

Choose your target and source MySQL connections. After choosing and testing your MySQL connections, click Next to continue.

Figure 10.24 MySQL Schema Transfer Wizard: Schema Selection

MySQL Schema Transfer Wizard: Schema Selection

Choose the schemas to migrate, and click Start Copy to begin copying the selected schemas from the source to target MySQL server.

Figure 10.25 MySQL Schema Transfer Wizard: Copy Databases

MySQL Schema Transfer Wizard: Copy Databases

Review the Message Log to confirm that the migration completed with success. Click Next to view a summary of the results.

Figure 10.26 MySQL Schema Transfer Wizard: Results

MySQL Schema Transfer Wizard: Results

Click Finish to close the wizard.