mysql分库备份脚本

#!/bin/sh
TIME=`date "+%F_%T"`
DIR=/backup
PASS=123456
#判断备份目录是否存在,如不存在则创建
[ -d "$DIR" ] || mkdir $DIR
#分库备份
for DB in `mysql  -uroot -p"$PASS" -e 'show databases' | grep -Ev '^(Database|information_schema|performance_schema)'`;do
        mysqldump -uroot -p"$PASS" -F --single-transaction --master-data=2 --default-character-set=utf8 -q  -B $DB | gzip > ${DIR}/${DB}_${TIME}.sql.gz
done