blob: 09c1bcafafe2f7af4c641fd76b0fc99c016eb19d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
create table t1 (a int) engine=innodb;
reset master;
set autocommit=0;
insert t1 values (1);
flush tables with read lock;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
master-bin.000001 98
commit;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
master-bin.000001 98
unlock tables;
drop table t1;
set autocommit=1;
|
