#!/bin/bash
#Author: Luca Limardo
#Purpose: Backup Mysql
#Date: 2014-02-19

DBUSER="user"
DBPASS="password"
BKPDIR=/path
NOW=$(date +%Y-%m-%d)
DAY=$(date +%a)
TMP=bkp.mysql.$NOW.$DAY

DATABASES=$(/usr/bin/mysql --user=$DBUSER --password=$DBPASS -e "SHOW DATABASES;" | tr -d "| " | grep -v Database)

rm -rf $BKPDIR/*.$DAY
mkdir $BKPDIR/$TMP

for DB in $DATABASES
do
  /usr/bin/mysqldump --force --opt --user=$DBUSER --password=$DBPASS --databases $DB > $BKPDIR/$TMP/$DB.sql
  echo $DB
done

wait

tar -czf $BKPDIR/bkp.mysql.$NOW.$DAY.tar.gz $BKPDIR/$TMP/*.sql
#echo "Zip"

wait

rm -rf $BKPDIR/$TMP
#echo "Rimuovo"

exit