MySQL分库备份shell脚本[root@node1 ~]# mysql -uroot -p'ruanganlove999' -e"show databases;"| grep -Evi "database|performance_schema|information_schema"|sed-r 's#^([a-z].*$)#mysqldump -uroot -pruanganlove999 --events -B\1|gzip>./\1.sql.gz#g'|bash
[root@node1 ~]# mysql -uroot -p'ruanganlove999' -e"show databases;"| grep -Evi "database|performance_schema|information_schema"|sed-r 's#^([a-z].*$)#mysqldump -uroot -pruanganlove999 --events -B\1|gzip>./\1.sql.gz#g'
Warning: Using a password on the command line interfacecan be insecure.
mysqldump -uroot -pruanganlove999 --events -Bakcms|gzip>./akcms.sql.gz
mysqldump -uroot -pruanganlove999 --events -Bmysql|gzip>./mysql.sql.gz
mysqldump -uroot -pruanganlove999 --events -Boldboy|gzip>./oldboy.sql.gz
mysqldump -uroot -pruanganlove999 --events -Boldboy_gbk|gzip>./oldboy_gbk.sql.gz
mysqldump -uroot -pruanganlove999 --events -Brsc_akcms|gzip>./rsc_akcms.sql.gz
mysqldump -uroot -pruanganlove999 --events -Btest|gzip>./test.sql.gz
[root@node1 ~]# ls
akcms.sql.gz install.log mysql.sql.gz oldboy_gbk.sql.gz test.sql.gz test2.sql
anaconda-ks.cfg install.log.syslog oldboy.sql.gz rsc_akcms.sql.gz test1.sql
