1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; drop table if exists t1; Warnings: Note 1051 Unknown table 't1' create table t1(id int); show tables; Tables_in_test t1 show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 278 flush logs; |