#!/bin/bash
#----------------------------------------
#OPTIONS
#----------------------------------------

USER='db_user_backups'                 # MySQL User
PASSWORD='secret'                      # MySQL Password
GZIP=0                                 # 1 = Compress
ID='###############################'   # Folder ID in gDrive
TMP_PATH="/backups/tmp"


# Create the backup folder
if [ ! -d $TMP_PATH ]; then
	mkdir -m 775 -p $TMP_PATH
	echo "Creating directory"
fi

# Get list of database names
databases=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "|" | grep -v Database`
#----------------------------------------

for db in $databases; do
	# Here add a database you want to exclude
	if [ $db == 'information_schema' ] || [ $db == 'performance_schema' ] || [ $db == 'mysql' ] || [ $db == 'sys' ] || [ $db == 'phpmyadmin' ]  ;  then
		continue
	fi

	date=$(date +%H_%d%m%Y)
	DUMP_OPTIONS="--complete-insert --no-create-info --extended-insert --single-transaction --ignore-table=$db.migrations"

	if [ "$GZIP" -eq 0 ] ; then
		echo "Backing up database: $db without compression"
		mysqldump -u $USER -p$PASSWORD  $db $DUMP_OPTIONS > $TMP_PATH/$date-$db.sql
		gdrive upload "$TMP_PATH/$date-$db.sql" --parent $ID --delete

	else
		echo "Backing up database: $db with compression"
		mysqldump -u $USER -p$PASSWORD $DUMP_OPTIONS $db | gzip -c > $TMP_PATH/$date-$db.sql.gz
		gdrive upload "$TMP_PATH/$date-$db.sql.gz" --parent $ID --delete
	fi

done