Perform a Test Backup and Restore of Microsoft Azure database for MySQL

To verify that the Azure Database for MySQL instance is set up correctly, perform a test backup and restore.

Back Up the Instance

1. From the Command Center navigation pane, go to Protect > Databases.

   The database Overview page appears.

2. Go to the Instances tab.

3. In the row for the instance, click the action button , and then click Backup. Alternatively, click the instance you want to backup, and then in the upper-right area of the window, click Backup.

   The Backup dialog box appears.

4. Select a subclient to back up, and then click SELECT.

   The Backup options dialog box appears.

5. Select a Backup level.

6. Click SUBMIT.

Restore the Instance

1. From the Command Center navigation pane, go to Protect > Databases.

   The database Overview page appears.

2. Go to Instances tab.

3. In the row for the instance, click the action button , and then click Restore. Alternatively, click the instance you want to backup, and then in the Recovery points tile, click Restore.

   The Backup Content page appears.

4. Select the backup content as per requirement, and then click RESTORE.

   The Restore options dialog box appears.

5. You can perform In place or Out of place restore as per the requirement.

6. Click Submit.