MySQL分库备份

方法一：通过awk实现

mysql -uroot -p123456 -e "show databases" | grep -ivE 'Database|information_schema|mysql|performance_schema' | awk '{print "mysqldump -uroot -p123456 -B",$0,"> /opt/"$0".sql"}' | bash

 

方法二：通过for循环实现

for dbname in  `mysql -uroot -p123456 -e "show databases" | grep -Evi "database|information_schema|performance_schema" `
do
     mysqldump -uroot -p123456 --events -B $dbname | gzip > /opt/bak/${dbname}_bak.sql.gz
done

这里注意在/opt目录下建立bak目录