Rediger

Restore an Azure Database for MySQL flexible server by using Azure Backup (preview)

Important

The preview solution for protecting Azure Database for MySQL flexible servers using Azure Backup is currently paused. Please refrain from configuring new backups until further notice. Rest assured, all existing backup data remains safe and available for restore. In the meantime, you can refer to the blog post instructions to create long-term backups manually, ensuring compliance with your immediate needs.

This article describes how to restore your Azure Database for MySQL flexible server by using Azure Backup.

Learn more about the supported scenarios, considerations, and limitations.

Prerequisites

Backup data is stored in the Backup vault as a blob within the Microsoft tenant. During a restore operation, the backup data is copied from one storage account to another across tenants. Ensure that the target storage account for the restore has the AllowCrossTenantReplication property set to true.

Restore the Azure Database for MySQL - Flexible Server

Note

You can restore the recovery point for a MySQL – flexible server database as files only.

To restore the database, follow these steps:

  1. Go to the Backup vault, and then select Backup instances.

  2. Select Azure Database for MySQL - Flexible Server (preview) > Restore.

    Screenshot that shows how to go to a backup instance.

  3. Choose Select restore point, and then select the point in time that you want to restore.

    To change the date range, select Time period.

    Screenshot that shows the selection of a point-in-time recovery point.

  4. On the Restore parameters tab, select the Target Storage account and Target Container values, and then select Validate.

    The validation process checks if the restore parameters and permissions are assigned for the restore operation.

    Screenshot that shows the selection of restore parameters.

  5. When the validation is successful, select Restore.

    This action restores the selected database backups in the target storage account.

    Screenshot that shows how to trigger restore operation.

Create a MySQL - Flexible server from restored recovery point

After the restore job completes successfully, you will see the restored files in the target storage account. You will need to copy these restored files to a MySQL server to access the restored data.

Access data from restored recovery point

To access data from the recovery point, follow these steps:

  1. Download the restored files from Azure Storage Account using Azure Storage explorer.

  2. Install the MySQL community version from here

    Note

    Ensure that the downloaded MySQL community version must be same or compatible with the version of the restored files.

  3. Open command prompt and navigate to the bin directory of the downloaded MySQL community version folder.

  4. Specify the data directory using --datadir by running following command in command prompt.

    mysqld --datadir=<path to data folder of the restore files downloaded>

    Note

    You can either add the bin folder path to the environment variables and run the mysqld command directly; or go to the bin folder path in command prompt and then run mysqld

  5. Connect to the database using a supported client.

Next steps

Back up an Azure Database for MySQL flexible server (preview). Troubleshoot Azure Database for MySQL - Flexible Server backup (preview).

  • Last updated on