source include/master-slave.inc; connection master; use test; drop table if exists t1; create table t1 (n int auto_increment primary key); set insert_id = 2000; insert into t1 values (NULL),(NULL),(NULL); save_master_pos; connection slave; use test; sync_with_master; select * from t1; connection master; --replace_result 9307 9999 3350 9999 3351 9999 show slave hosts; drop table t1; save_master_pos; connection slave; sync_with_master; slave stop; connection master; drop table if exists t2; create table t2(id int auto_increment primary key, created datetime); set timestamp=12345; insert into t2 set created=now(); select * from t2; save_master_pos; connection slave; slave start; sync_with_master; select * from t2; connection master; drop table t2; save_master_pos; connection slave; sync_with_master;