source include/master-slave.inc; source include/have_default_master.inc; connection master; show master status; save_master_pos; connection slave; sync_with_master; show slave status; change master to master_log_pos=73; slave stop; change master to master_log_pos=73; show slave status; slave start; show slave status; change master to master_log_pos=173; show slave status; connection master; show master status; create table if not exists foo(n int); drop table if exists foo; create table foo (n int); insert into foo values (1),(2),(3); save_master_pos; connection slave; change master to master_log_pos=73; sync_with_master; select * from foo; connection master; drop table foo; save_master_pos; connection slave; sync_with_master;