数据库分页备份

mysql -e ‘show databases;‘ |grep -Ev ‘Database|information_schema|performance_schema‘ |sed -r "s@(.*)@mysqldump -B \1 |gzip > \/date\/\1.sql.gz1@" | bash

for i in mysql -e ‘show databases;‘ |grep -Ev ‘Database|information_schema|performance_schema‘ ;do mysqldump -B $i |gzip > ${i}.sql.gz ;done

数据库分页备份

标签：ase   mysqldump   dump   rman   format   gzip   bash   done   mys