[root@centos7 ~]#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
[root@centos7 ~]#mysql -e 'show databases'|grep -Ev '^(information_schema|performance_schema|Database)$'|sed -rn 's@(.*)@mysqldump -B \1 --single-transaction --master-data=2 |gzip > /data/\1\.sql\.gz@p'|bash
数据库中如何恢复误删除的表
最新推荐文章于 2024-01-03 15:40:49 发布