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 to extract the backup dump
5- Backup file is ready and in this example it is under File System "cs47e4f0dddd931x4619xbf7", navigate on the Azure Portal to that file system, as in the following screenshot.
6- Download backup file if needed or alternatively move it to Blob Storage using AzCopy utility
Note: this technique leverages the cloud shell storage, if you are interested in extracting the dump to another blob storage please check the steps here: https://techcommunity.microsoft.com/t5/azure-database-for-mysql/steps-to-automate-backups-of-your-az...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.