for i in mysql -e ‘show databases;‘ |grep -Ev ‘Database|information_schema|performance_schema‘ ;do mysqldump -B $i |gzip > ${i}.sql.gz ;done
mysql -e ‘show databases;‘ |grep -Ev ‘Database|information_schema|performance_schema‘
数据库分页备份
原文:https://blog.51cto.com/14114496/2353701