Often customers want to backup Azure Database for MySQL to a Blob storage. mysqldump utility can't directly write the output file on a Blob Storage, in this post I will explain how this can be done u...
Updated Oct 17, 2020
Version 3.0
Blog Post
Ops_Biren , thanks for your comment, restore from Azure Blog Storage should be similar
1- Navigate to your Azure Database for MySQL server on the portal and Run Azure Cloud Shell (Bash). If you run this for the first time it will ask you to create a Storage container and and this will mount an Azure File in it.
2- Type df in the cloud shell and collect the Azure File path
3- Change directory to the cloud drive using the cd command
in the example below I used cd /usr/bashar/clouddrive
4- Now that you are in that directory run mysql command,
example: mysql -h mydemoserver.mysql.database.azure.com -u myadmin@mydemoserver -p testdb < testdb_backup.sql
ref: https://docs.microsoft.com/en-us/azure/mysql/concepts-migrate-dump-restore#restore-your-mysql-database-using-command-line-or-mysql-workbench