- source include/master-slave.inc;
- connection master;
- drop table if exists t1;
- create table t1(n int primary key);
- !insert into t1 values (1),(2),(2);
- insert into t1 values (3);
- save_master_pos;
- connection slave;
- sync_with_master;
- @r/rpl000003.result select * from t1;
- connection master;
- drop table t1;
- save_master_pos;
- connection slave;
- sync_with_master;