#!/bin/bash
#ssullivan@liquidweb.com
datadumpdir='/backup/dumps/'
date=$(/bin/date +%HHours%m-%d-%Y)
datadir=$(/usr/bin/mysql -e "show variables like 'datadir'" | grep / | cut -f 2)
mkdir -p $datadumpdir$date
cd $datadumpdir$date
for i in `mysql -e "show databases;" | sed 's/Database$//'`; do
        mysqldump --opt $i > $datadumpdir$date/$i.sql;
        tar -pczf $i.tar.gz $datadumpdir$date/$i.sql &> /dev/null
        rm -rf $datadumpdir$date/$i.sql
done
find $datadumpdir/* -mtime +56 -type d -exec rm -rf {} \;