#!/bin/bash
USER="root"
PASSWD="root"
HOST="localhost"
MYSQL="/opt/mysql/bin/mysql"
MYSQLDUMP="/opt/mysql/bin/mysqldump"
DATE=`date -I`
BACKUP="/home/data/bak"
DATABASES=`$MYSQL -u$USER -p$PASSWD -h$HOST -Bse "show databases"|grep -Ev "(mysql|info|test|schema)" `
for i in $DATABASES
do
if [ ! -d $BACKUP/$DATE ] ; then
mkdir $BACKUP/$DATE
fi
echo -e "Now dump $i"
$MYSQLDUMP -u$USER -p$PASSWD $i | gzip > $BACKUP/$DATE/$i.sql.gz
done
cd $BACKUP
find $BACKUP -ctime +7 -exec rm -rf {} \; #保留7天的备份