#!/bin/sh

DATETIME=$(date +%Y-%m-%d_%H.%M)
TMPDIR="/home/th0th/tmp/backup_dbs"
BACKUPDIR="$TMPDIR/$DATETIME"
DROPBOXDIR="/home/th0th/Dropbox/dbs"
USER="<user>"
PASS="<password>"

DBS="db1 db2 db3"

mkdir -p "$BACKUPDIR"

for DB in $DBS; do
    mysqldump --user=$USER --password=$PASS $DB > "$BACKUPDIR/$DB.sql"
done

tar -C "$TMPDIR" -czf "$DROPBOXDIR/dbs_$DATETIME.tar.gz" "$DATETIME"
rm -rf "$BACKUPDIR"