Migrating from MySQL 5.5 to MySQL 5.6

This page discusses how to migrate from MySQL 5.5 to MySQL 5.6. The default instance version when you create an instance is MySQL 5.5. You must explicitly select MySQL 5.6.

If you already have a 5.5 instance and you would like to try 5.6, then follow the migrating instructions given below.

Contents

MySQL 5.6 features

Cloud SQL MySQL 5.6 supports:

• Binary log scalability & group commit
• Improved geo spatial functionality
• Full text search for InnoDB tables
• Various performance improvements, see What Is New in MySQL 5.6

Cloud SQL does not support:

• Performance schema
• InnoDB memcached plugin

Migrating

The steps for migrating an instance from MySQL 5.5 to 5.6 involve exporting data from the MySQL 5.5 instance and importing that data into the 5.6 instance.

To migrate an instance from MySQL 5.5 to 5.6:

1. Create a Cloud Storage bucket , with read and write access.

2. In the Google Developers Console, go to the Overview page of the MySQL 5.5 instance and click Export .

3. Be sure to export all, unless you only want some of the databases on the instance you are migrating. Also, for large databases, use .gz in the file name to compress the data. For more details see Exporting data .

4. Verify the exported data file exists in the storage bucket. For example, you can use the Google Developers Console to check.

5. Create a new MySQL 5.6 instance. Be sure to select MySQL 5.6 if you are creating a new instance. For more details, see Creating an instance . The MySQL version of an instance is displayed on the Overview page of an instance, under Properties .

6. In the Google Developers Console, go to the Overview page of the MySQL 5.6 instance and click Import . For more details about importing, see Importing data .

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License , and code samples are licensed under the Apache 2.0 License . For details, see our Site Policies .