#!/bin/sh
# MySQL Backup

DIRS="/home/alcides/admin /home/alcides/sites"

NOW=$(date +"%Y-%m-%d")
DAY=$(date +"%a")
FULLBACKUP="Sun"
BACKUP=/home/alcides/backups/$NOW

MUSER="root"
MPASS="youwish"
MHOST="localhost"

EMAIL="me@alcidesfonseca.com"

MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"

[ ! -d $BACKUP ] && mkdir -p $BACKUP || :

if [ "$DAY" == "$FULLBACKUP" ]; then
	FILE="filesystem.tar.gz"
	tar -zcvf $BACKUP/$FILE $DIRS
fi

DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
for db in $DBS
do
FILE=$BACKUP/mysql-$db.gz
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
done