#!/bin/bash
#ssullivan@liquidweb.com
datadumpdir='/home/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
echo "Creating MySQL dumps in $datadumpdir$date .."
for i in `mysql -e "show databases;" | sed 's/Database$//'`; do
 	mysqldump --opt $i > $datadumpdir$date/$i.sql;
	echo "Created: $i.sql"
done
echo "Backups created in $datadumpdir$date"
find $datadumpdir/* -mtime +5 -type d -exec rm -rf {} \;