Back up 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 point in time in the last seven days or from any specific snapshot backup that's 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 as shown here:

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 that's 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 point in time in the last seven days. The system automatically creates another server and restores the data to the new server.

  1. Sign in to the Azure portal, and then select your server.

  2. On the Overview page, select Restore.

    Restore to any point in time

  3. Select the restore point UTC, enter a completely new server name, select the location of the server, and then select configure the performance. To start restoring, select Confirm.

    Note

    If you select a location that is different than the original server, the system automatically uses geo-replication technology to restore to the new server in the region that you select.

    Restore to any point in time

The data recovery process might take from a few minutes to several hours, depending on the point in time 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 must change the server name prefix in the account to the new server name.