Edit

Trigger on-demand backup of an Azure Database for MySQL - Flexible Server instance by using the Azure portal

  • Article

APPLIES TO: Azure Database for MySQL - Flexible Server

This article provides a step-by-step procedure to trigger an on-demand backup from the Azure portal.

Prerequisites

You need an Azure Database for MySQL flexible server instance to complete this how-to guide.

Trigger on-demand backup

Follow these steps to trigger backup on demand:

  1. In the Azure portal, choose your Azure Database for the MySQL flexible server instance you want to back up.

  2. Under Settings select Backup and restore from the left panel.

  3. From the Backup and restore page, select Backup Now.

  4. Now on the Take backup page, in the Backup name field, provide a custom name for the backup.

  5. Select Trigger

    Screenshot showing how to trigger an on-demand backup.

  6. Once completed, the on-demand and automated backups are listed.

Trigger an On-Demand Backup and Export (preview)

Follow these steps to trigger an on-demand backup and export:

  1. In the Azure portal, choose your Azure Database for MySQL flexible server instance to take a backup of and export.

  2. Under Settings select Backup and restore from the left panel.

  3. From the Backup and restore page, select Export now.

    Screenshot of the export now option is selected.

  4. When the Export backup page is shown, provide a custom name for the backup in the Backup name field or use the default populated name.

    Screenshot of providing a custom name for the backup in the backup name field.

  5. Select Select storage, then select the storage account, which is the target for the on-demand backup to be exported to.

    Screenshot of selecting the storage account.

  6. Select the container from the list displayed, then Select.

    Screenshot of listing the containers to use.

  7. Then select Export.

    Screenshot of the Export button to choose what to export.

  8. You should see the exported on-demand backup in the target storage account once exported.

  9. If you don't have a precreated storage account to select from, select "+Storage Account," and the portal initiates a storage account creation workflow to help you create a storage account to export the backup.

Restore from an exported on-demand full backup

  1. Download the backup file from the Azure storage account using Azure Storage Explorer.

  2. Install the MySQL community version from MySQL. Download MySQL Community Server. The downloaded version must be the same or compatible with the version of the exported backups.

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

  4. Now specify the data directory using --datadir by running the following command at the command prompt:

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

  5. Connect to the database using any supported client.

Related content