#!/bin/bash
NOW=$(date +"%Y-%m-%d-%H%M")
FILE="backup.$NOW.tar"
BACKUP_DIR="/home/backups/"
WWW_DIR="/var/www/html/"

DB_USER="root"
DB_PASSWD="mypass"
DB_FILE="backup.$NOW.sql"

WWW_TRANSFORM='s,^var/www/html,'
DB_TRANSFORM='s,^home/backups,database,'

tar -cf $BACKUP_DIR/$FILE --transform $WWW_TRANSFORM $WWW_DIR

for db in $(mysql --user=$DB_USER --password=$DB_PASSWD -e 'show databases' -s --skip-column-names|grep -viE '(staging|performance_schema|information_schema)');
    do mysqldump --user=$DB_USER --password=$DB_PASSWD --events --opt --single-transaction $db | gzip > $BACKUP_DIR/$DB_FILE;
done

tar --append --file=$BACKUP_DIR/$FILE --transform $DB_TRANSFORM  $BACKUP_DIR/$DB_FILE
rm $BACKUP_DIR/$DB_FILE
gzip -9 $BACKUP_DIR/$FILE

echo 'backup finished', $FILE