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