Restoring MySQL Databases for an Azure Database

You can restore MySQL databases to the same Azure database instance as the backup, or a new Azure database instance. You can perform the restore operation from the Azure Virtualization client computer.

Before You Begin

• Create a subclient for the databases. For more information, see Creating MySQL Subclient for an Azure Database.

• Perform a backup operation. For more information, see Performing a MySQL Database Backup Operation for an Azure Database.

Procedure

1. From the CommCell Browser, expand Client Computers > client > MySQL.

2. Right-click the instance, point to All Tasks, and then click Browse and Restore.

   The Browse and Restore Options dialog box appears.

3. On the Time Range tab, select the backup:

   • To restore the most recent backup, select Latest Backup.

   • To restore to a point-in-time, select Time Range, and then in the Start and End boxes, type the date and time.

4. Click View Content.

5. On the Browse page, select the data to restore:

   1. Beside each database to restore, select the check box.

   2. Beside innodb, if the box is selected, clear the check box.

   3. Click Recover All Selected.

      The Restore Options dialog box appears.

6. On the General tab, from the Destination client list, select the client.

7. Click OK.