Shell实现备份数据库

#!/bin/bash
mysql -uroot -pChenbo@123 -e 'show databases;' | egrep -v 'information_schema|performance_schema|sys' > /tmpdb/alldb.sql

while read db
do
  mysql -uroot -pChenbo@123 -e "show tables from $db;" > /tmptb/"$db".alltb
  while read tb
  do
    mysqldump -uroot -pChenbo@123 --set-gtid-purged=OFF "$db" "$tb"| gzip > /mq/$db/"$tb".sql.gz
  done < /tmptb/$(db).alltb
  rm -rf /tmptb/$(db).alltb
done < /tmpdb/alldb.sql
rm -rf /tmpdb/alldb.sql