Migrating MySQL Data

You can migrate your on-premises MySQL Database database to a MySQL Cloud Service using the method described here.

Some of the characteristics and factors to consider when choosing a migration method are:

  • On-premises database version

  • Oracle MySQL Cloud Service database version

  • On-premises host operating system and version

  • Quantity of data, including indexes

  • Storage for data staging

  • Acceptable length of system outage

  • Network bandwidth

To migrate your data from an on-premises MySQL database to a MySQL Cloud Service database, it is strongly recommended to export your local database and copy the dump to the compute node before importing into the MySQL Cloud Service.

  1. Back up your local server, preferably using MySQL Enterprise Backup. For more information, see Backing Up a Database Server.

  2. Copy the backup to your cloud service, using rsync, or scp for example.

  3. Import the backup to your cloud service’s MySQL Server, using the cloud service installation of MySQL Enterprise Backup. For more information on importing a backup, see Restoring a Database.