rpl_row_drop.result

开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

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;
**** On Master ****
CREATE TABLE t1 (a int);
CREATE TABLE t2 (a int);
CREATE TEMPORARY TABLE t2 (a int, b int);
SHOW TABLES;
Tables_in_test
t1
t2
**** On Slave ****
SHOW TABLES;
Tables_in_test
t1
t2
**** On Master ****
DROP TABLE t2;
SHOW TABLES;
Tables_in_test
t1
t2
**** On Slave ****
SHOW TABLES;
Tables_in_test
t1
t2
**** On Master ****
CREATE TEMPORARY TABLE t2 (a int, b int);
SHOW TABLES;
Tables_in_test
t1
t2
**** On Slave ****
SHOW TABLES;
Tables_in_test
t1
t2
**** On Master ****
DROP TABLE t1,t2;
SHOW BINLOG EVENTS;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	102	Server ver: VERSION, Binlog ver: 4
master-bin.000001	102	Query	1	188	use `test`; CREATE TABLE t1 (a int)
master-bin.000001	188	Query	1	274	use `test`; CREATE TABLE t2 (a int)
master-bin.000001	274	Query	1	378	use `test`; DROP TABLE `t1` /* generated by server */
SHOW TABLES;
Tables_in_test
t2
**** On Slave ****
SHOW TABLES;
Tables_in_test
t2