MySQL Backup to Google Drive (requires gdrive)

backup.sh

#!/bin/bash

# backup Path
BACKUP_PATH="./mysql"

# database settings
DB_NAME=$1
DB_USER="user"
DB_PASS="password"

# current timestamp
TIMESTAMP=$(date +%s)

# google drive folder
googleFolderID="insertgooglefolderidhere"

FILENAME=${DB_NAME}_${TIMESTAMP}.sql

# svn up the content
cd ${BACKUP_PATH}

# remove previous backups
rm ./*.sql
rm ./*.gz

# dump the database using the mysql administrator - so we can see all dbs
mysqldump -u$DB_USER -p$DB_PASS --opt --routines --skip-extended-insert --compact --force "${DB_NAME}" > "${FILENAME}"

# compress file
tar -czvf ${FILENAME}.gz ${FILENAME}

# upload file to google drive
$GOPATH/bin/gdrive upload --parent ${googleFolderID} ${FILENAME}.gz

called with ./mysql dbname