mysqlbinlog查询时通过--database=db1选项指定某一具体数据库时,使用statement log模式只有在显示输入use db1之后的语句才会被mysqlbinlog输出。如:
INSERT INTO test.t1 (i) VALUES(100);
INSERT INTO db2.t2 (j) VALUES(200);
USE test;
INSERT INTO test.t1 (i) VALUES(101);
INSERT INTO t1 (i) VALUES(102);
INSERT INTO db2.t2 (j) VALUES(201);
USE db2;
INSERT INTO test.t1 (i) VALUES(103);
INSERT INTO db2.t2 (j) VALUES(202);
INSERT INTO t2 (j) VALUES(203);
如果使用mysqlbinlog --database=test ,只会输出USE test之后的中间三句
转载于:https://blog.51cto.com/hdl993101/1978340