source include/master-slave.inc; create table t1 (a int); create table t2 (a int); insert into t1 values (1); insert into t2 values (1); delete t1.* from t1, t2 where t1.a = t2.a; save_master_pos; select * from t1; select * from t2; connection slave; sync_with_master; select * from t1; select * from t2; connection master; drop table t1,t2; save_master_pos; connection slave; sync_with_master;