create database olddog;
use olddog;
create table w1(id int);
insert into w1 values(1),(2),(3);
commit;
单库单表备份数据
mysql> select concat("mysqldump -uroot -p123456 ",table_schema," ",table_name," --master-data=2 --singlegle-transaction -R -E --triggers>/backup/",table_schema,"_",table_name,".sql") from information_schema.tables where table_schema not in ('sys','mysql','information_schema','performance_schema') into outfile '/tmp/out.sql';
cat /tmp/out.sql
[root@db01]#sh /tmp/out.sql
单库单表全备
备份后的操作
insert into w1 values(111),(222),(333);
insert into w1 values(11),(22),(33);
commit;