Creating a New MySQL Cloud Service Instance from a Backup

Before You Begin

This 15-minute tutorial shows you how to migrate a database to MySQL Cloud Service by creating a new MySQL Cloud Service instance from a backup.

Background

You can migrate a MySQL database from your local computer to a MySQL Cloud Service by uploading a compressed, transportable tablespace (TTS) backup image file and creating a new MySQL Cloud Service instance from the backup.

What Do You Need?

• A MySQL database that you intend to migrate to MySQL Cloud Service
• MySQL Enterprise Backup
• Access to the Oracle Cloud Storage Service
• Access to the MySQL Cloud Service
• Experience with creating a MySQL Cloud Service instance, including providing a public key, configuring the instance, and configuring backup and recovery options. If you have never created a MySQL Cloud Service, review the Getting Started with MySQL Cloud Service tutorial.

Creating a Backup of Your Database to Migrate

Use MySQL Enterprise Backup to create a compressed, transportable tablespace (TTS) image backup of the database you intend to migrate.

Enter the mysqlbackup command. To back up all tables in mydatabase, using mybackupdir as the temporary directory and including the --compress and --use-tts options, enter the following command:

mysqlbackup --include-tables=mydatabase.* --backup-dir=mybackupdir --backup-image=~/mydatabase.mbi --compress --use-tts backup-to-image -u root -p

Creating a Storage Cloud Container

1. Open your browser and log into your cloud account.
2. Navigate to Storage Classic console.
3. Click Create Container

   

4. Enter a name for your storage container and click Create

   

Uploading a Backup to Oracle Storage Classic

1. Select your container from the Container List.



2. Click Upload Objects.



3. Navigate to select your database backup image file and click Open.



When the upload completes, the uploaded backup image file is displayed in the storage container.

Creating a MySQL Cloud Service Instance from a Backup

1. Navigate to your MySQL Cloud Service Console.
2. Click Create Service.

   

3. Enter a Service Name and Service Description. Click Next.

   

4. Provide the SSH Key for the Configuration. Enter or update values for the MySQL Configuration. Set up Backup and Recovery Configuration options.

   

5. Under Initialize Data From Backup, for Create Instance from Existing Backup, select Yes.

   

6. Enter the Backup File Cloud Storage Path in the format
   storageservicename-cloudaccountname/containername/backupfilename. For example:
   Storage-mytestcorp/mystoragecontainer/mydatabase.mbi. Enter your Username and Password for your cloud service account.

   

7. Click Next.

   

The service creation process starts. When the service creation is complete, the new instance appears in the list of Services.

Want to Learn More?

• Getting Started with MySQL Cloud Service OBE
• Using Oracle MySQL Cloud Service in the Oracle Help Center