MySQL数据库分库备份

#!/bin/bash
#Date:2022-03-28
#Function:backup database
PATH="/path/mysql/bin:$PATH"
dbpath=/dbdata/backup
myuser=root
mypass=123
mycmd="mysql -u$myuser -p$mypass"
mydump="mysqldump -u$myuser -p$mypass -B --master-data=2 --single-transaction"
[ ! -d "$dbpath" ] && mkdir -p $dbpath
for db_name in `$mycmd -e "show databases;"|sed '1,2d'|egrep -v "mysql|schema|sys"`
do
    $mydump $db_name|gzip >$dbpath/${db_name}_$(date +%F).sql.gz
done

如有错误，请指正。