利用脚本实现分库备份

[root@centos_9 ~]# vim fenku_backup.sh

#!/bin/bash

for db in `mysql -e 'show databases'|grep -Ev '^(information_schema|performance_schema|Database)$'`;do

       mysqldump -B $db --single-transaction --master-data=2 |gzip > /data/$db.sql.gz ;

done

 

mysql -e 'show databases'|grep -Ev '^(information_schema|performance_schema|Database)$'|sed -rn 's@(.*)@mysqldump -B \1 --single-transaction --master-da ta=2 |gzip > /data/\1\.sql\.gz@p'|bash

 

#两种方法都是可以的 `