#/bin/bash
# author george zheng <xinhaozheng@gmail.com>
# 2012 - 03 - 12
# version 1.2
MYUSER="root"
MYPASS=k943587@djj^&AS
HOST="localhost"
DATE=$(date -I)
NAME=$(date +%Y%m%d-%H%M%S)
BACKUPDIR="/home/mysqlbak"
[ ! -d $BACKUPDIR ] && mkdir -p $BACKUPDIR
DBS=`mysql -u$MYUSER -p$MYPASS -Bse "show databases"|grep -v "information_schema" |grep -v "test" | grep -v "mysql" `
echo "Backuping mysql datebase , please waiting..."
for db_name in $DBS
do
echo "Backup datebase $db_name ..."
[ ! -d $BACKUPDIR/$DATE ] && mkdir -p $BACKUPDIR/$DATE
mysqldump --default-character-set utf8 -u$MYUSER -p$MYPASS -h$HOST $db_name |gzip > $BACKUPDIR/$DATE/$db_name$NAME.sql.gz
done
echo "Backup mysql datebase finished."