Point-in-time restore of an Azure Database for MySQL - Flexible Server with Azure CLI
[APPLIES TO: Azure Database for MySQL - Flexible Server
This article provides step-by-step procedure to perform point-in-time recoveries in flexible server using backups.
An Azure account with an active subscription.
If you don't have an Azure subscription, create an Azure free account before you begin. With an Azure free account, you can now try Azure Database for MySQL - Flexible Server for free for 12 months. For more information, see Try Flexible Server for free.
Install or upgrade Azure CLI to the latest version. See Install Azure CLI.
Login to Azure account using az login command. Note the id property, which refers to Subscription ID for your Azure account.
If you have multiple subscriptions, choose the appropriate subscription in which you want to create the server using the
az account setcommand. `
az account set --subscription <subscription id>
Create a MySQL Flexible Server if you have not already created one using the
az mysql flexible-server createcommand.
az mysql flexible-server create --resource-group myresourcegroup --name myservername
Restore a server from backup to a new server
You can run the following command to restore a server to an earliest existing backup.
az mysql flexible-server restore --restore-time --source-server [--ids] [--location] [--name] [--no-wait] [--resource-group] [--subscription]
Restore a server from this
2021-03-03T13:10:00Z backup snapshot.
az mysql flexible-server restore \ --name mydemoserver-restored \ --resource-group myresourcegroup \ --restore-time "2021-03-03T13:10:00Z" \ --source-server mydemoserver
Time taken to restore will depend on the size of the data stored in the server.
Geo-Restore a server from geo-backup to a new server
You can run the following command to geo-restore a server to the most recent backup available.
az mysql flexible-server geo-restore --source-server --location [--name] [--no-wait] [--resource-group] [--subscription]
Example: Geo-restore 'mydemoserver' in region East US to a new server 'mydemoserver-restored' in it’s geo-paired location West US with the same network setting.
az mysql flexible-server geo-restore \ --name mydemoserver-restored \ --resource-group myresourcegroup \ --location "West US" \ --source-server mydemoserver
Perform post-restore tasks
After the restore is completed, you should perform the following tasks to get your users and applications back up and running:
- If the new server is meant to replace the original server, redirect clients and client applications to the new server
- Ensure appropriate VNet rules are in place for users to connect. These rules are not copied over from the original server.
- Ensure appropriate logins and database level permissions are in place
- Configure alerts as appropriate for the newly restore server
Learn more about business continuity
Submit and view feedback for