Shell script to automate mysql enterprise backup

#Shell script to automate mysql enterprise backup download

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.

#Shell script to automate mysql enterprise backup download

In the example below I used cd /usr/bashar/clouddriveР”В¤- Now that you are in that directory run mysqlcommand to extract the backup dumpР”Тђ- 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.Р”В¦- Download backup file if needed or alternatively move it to Blob Storage using AzCopy utility 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.Р”Сћ- Type df in the cloud shell and collect the Azure File pathР”Р€- Change directory to the cloud drive using the cd command 1- Navigate to your Azure Database for MySQL server on the portal and Run Azure Cloud Shell (Bash).