Perform a Test Backup and Restore for Azure MySQL Instance

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

Back Up the Instance

From the navigation pane, go to Protect > Databases.

The database Overview page appears.
Go to the Instances tab.
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.
Select a subclient to back up, and then click Select.

The Backup options dialog box appears.
Select a Backup level.
Click Submit.

From the navigation pane, go to Protect > Databases.

The Instances page appears.
In the row for the instance, click the action button, and then click Restore.

The Backup content dialog box appears.
Select the backup, and then click Restore.

The Restore options dialog box appears.
Click Submit.
From the navigation pane, go to Protect > Databases.

The database Overview page appears.
Go to Instances tab.
In the row for the instance, click the action button 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.
Select the backup content as per requirement, and then click Restore.

The Restore options dialog box appears.
You can perform In place or Out of place restore as per the requirement.
Click Submit.