Backup and restore a MySQL Database on Azure
The MySQL Database on Azure option on the Azure portal supports full backups and incremental backups. Full backups are also known as snapshot backups. Space that's used for backups doesn’t count toward the storage limit of the database. You can restore from any time point in the last seven days or from any specific snapshot backup that's stored in the system. You can go back to any time point in the last seven days or any specific snapshot backup stored in the system.
Full backups
MySQL Database on Azure automatically backs up your MySQL database every day at the time that you specify. This is a full backup. Full backups are retained for 30 days. You can configure the daily backup time:
Incremental backups
MySQL Database on Azure automatically backs up newly added sections or changes to the database for the last seven days to enable rollback based on any point in time. You don't need to do anything for this backup to happen.
Restore the database to any point in time
MySQL Database on Azure supports restoring to any time point in the last seven days. The system will automatically create another server and restore to the new server.
Log in to the Microsoft Azure Management Portal and select your server.
On the Overview page, click Restore.
- Select the restore point UTC, enter a completely new server name, select the location of the server, and configure the performance. Press Confirm to start restoring.
[!NOTE]
If you selected a location that is different to the original server, the system will automatically use geo-replication technology to restore to the new server in the region that you selected.
The data recovery process might take from a few minutes to several hours, depending on the time point that you choose and the amount of data that was added to the database server that day.
[!NOTE]
You can access the new server instance by using the original server instance account. However, you will need to change the server name prefix in the account to the new server name.