mysql分库备份脚本

#!/bin/bash

#分库备份脚本
set -ue
user='root'
pass='Asd123456!'
basedir=/data/bak
TIME=`date "+%F_%T"`

for DB in `mysql  -e 'show databases' | grep -Ev "Database|information_schema|performance_schema|sys" `;do
	mkdir -p ${basedir}/${TIME}

	mysqldump  -F -E -R --triggers  --single-transaction --master-data=2 \
 --default-character-set=utf8 -q  -B $DB | gzip > ${basedir}/${TIME}/${DB}_${TIME}.sql.gz

done