source include/master-slave.inc; set SQL_LOG_BIN=0; create table t1 (word char(20) not null, index(word)); load data infile '../../std_data/words.dat' into table t1; create table t2 (word char(20) not null); load data infile '../../std_data/words.dat' into table t2; create table t3 (word char(20) not null primary key); connection slave; load table t1 from master; load table t2 from master; load table t3 from master; check table t1; select count(*) from t2; select count(*) from t3; connection master; set SQL_LOG_BIN=1; drop table if exists t1,t2,t3; save_master_pos; connection slave; sync_with_master; create table t1(n int); drop table t1;