分库备份脚本

#!/bin/bash
TIME=$(date +%F_%H-%M-%S)
DIR=/backup
PASS=123456

[ -d ${DIR} ] || mkdir ${DIR}

for DB in $(mysql -u root -p "${PASS}" -e 'show databases' | grep -Ev "^Database|.*schema$");
do
mysqldump -F --single-transaction --master-data=2 --default-character-set=utf8 -q -B ${DB} | gzip > ${DIR}/${DB}_${TIME}.sql.gz
done