blob: 1d045b21763d2214cd258b73c8e10f1b2b7ea9a6 (
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 102
commit;
show master status;
File Position Binlog_Do_DB Binlog_Ignore_DB
master-bin.000001 102
unlock tables;
drop table t1;
set autocommit=1;
|
