Backup MySQL dump to Azure Blob Storage

mysql_backup_to_azure_blob.sh

#!/bin/sh
export BACKUP_FILE=/opt/backup/db-backup.sql.gz
export DATABASE_SCHEMA_NAME=--all-databases
export AZURE_CONTAINER=YOUR_VALUE_HERE
export AZURE_NAME=YOUR_VALUE_HERE
export AZURE_KEY=YOUR_VALUE_HERE
export INSTANCE_NAME=YOUR_VALUE_HERE
export AZURE_BLOB_NAME=${INSTANCE_NAME}-$(date +%Y%m%d%H%M%S).sql.gz
export AZURE_BLOB_NAME_LATEST=${INSTANCE_NAME}-latest.sql.gz

/usr/bin/mysqldump $DATABASE_SCHEMA_NAME | gzip -9 > ${BACKUP_FILE}
azure storage blob upload -q -a ${AZURE_NAME} -k ${AZURE_KEY} --container ${AZURE_CONTAINER} -f ${BACKUP_FILE} -b ${AZURE_BLOB_NAME}
azure storage blob upload -q -a ${AZURE_NAME} -k ${AZURE_KEY} --container ${AZURE_CONTAINER} -f ${BACKUP_FILE} -b ${AZURE_BLOB_NAME_LATEST}