Shell script to dump mysql db and upload it to Back Blaze

backup.sh

#!/bin/bash

DB_NAME=""
DB_PASSWORD=""
DB_USER=""
DB_HOST=""
TODAY_DATE="$(date +'%d_%m_%Y_%H_%M_%S')"
FILENAME="$DB_NAME$TODAY_DATE".gz
BACKUP_DIR="/home/aslam/backup/$FILENAME"

# dump db in backup folder
echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')"
mysqldump -u $DB_USER -p$DB_PASSWORD -h $DB_HOST -e --opt -c $DB_NAME | gzip -c > $BACKUP_DIR
echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')"

# upload to b2
B2_ACC_ID=""
B2_APP_KEY=""
B2_BUCKET_NAME=""

echo "starting upload db to b2 at $(date +'%d-%m-%Y %H:%M:%S')"
/usr/local/bin/b2 authorize-account $B2_ACC_ID $B2_APP_KEY
/usr/local/bin/b2 upload_file $B2_BUCKET_NAME $BACKUP_DIR $FILENAME
echo "finished uploading db to b2 at $(date +'%d-%m-%Y %H:%M:%S')"

exit 0

How to run

• pip install --ignore-installed b2
• chmod +x backup.sh
• bash backup.sh