Send MySQL Backup to Google Cloud Storage(GCS)

mysql-gcs-backup.sh

#!/bin/bash

TIMESTAMP=$(date +"%Y-%m-%d_%H-%M-%S")
BACKUP_DIR="/home/ubuntu/backup/$TIMESTAMP"
MYSQL_USER="****"
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD="****"
MYSQLDUMP=/usr/bin/mysqldump

mkdir -p "$BACKUP_DIR/"

databases="db1 db2 db3 db4"

for db in $databases; do
  $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db --routines | gzip > "$BACKUP_DIR/$db-$TIMESTAMP.gz"
  gsutil cp $BACKUP_DIR/$db-$TIMESTAMP.gz gs://mydb-$db-backup/
done

in case if someone wants to run this script with cron, gsutil would need additional context. add following to the beginning of the script.

export HOME=/home/user
export PATH=/snap/bin # otherwise need to call gsutil with full path
export BOTO_CONFIG=/home/user/.boto # for authentication