1stop slave; 2drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; 3reset master; 4reset slave; 5drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; 6start slave; 7drop database if exists mysqltest; 8create database mysqltest; 9create table mysqltest.t1 ( n int); 10insert into mysqltest.t1 values(1)/ 11insert into mysqltest.t1 values(2); 12insert into mysqltest.t1 values(3); 13insert into mysqltest.t1 values(4); 14insert into mysqltest.t1 values(5)/ 15select * from mysqltest.t1; 16n 171 182 193 204 215 22show binlog events from 102; 23Log_name Pos Event_type Server_id End_log_pos Info 24master-bin.000001 # Query 1 # # 25master-bin.000001 # Query 1 # # 26master-bin.000001 # Query 1 # # 27master-bin.000001 # Table_map 1 # # 28master-bin.000001 # Write_rows 1 # # 29master-bin.000001 # Table_map 1 # # 30master-bin.000001 # Write_rows 1 # # 31master-bin.000001 # Table_map 1 # # 32master-bin.000001 # Write_rows 1 # # 33master-bin.000001 # Table_map 1 # # 34master-bin.000001 # Write_rows 1 # # 35master-bin.000001 # Table_map 1 # # 36master-bin.000001 # Write_rows 1 # # 37drop database mysqltest; 38