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 https://docs.microsoft.com/en-us/azure/cloud-shell/quickstartIf 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