rpl_row_basic_11bugs.test

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

--source include/have_row_based.inc
--source include/have_binlog_format_row.inc
--source include/master-slave.inc

# Bug#15942 (RBR ignores --binlog_ignore_db and tries to map to table
# on slave for writes)

CREATE DATABASE test_ignore;      # --binlog_ignore_db=mysqltest_ignore

--echo **** On Master ****
SHOW DATABASES;
USE test;
CREATE TABLE t1 (a INT, b INT);
SHOW TABLES;
INSERT INTO t1 VALUES (1,1), (2,2);
USE test_ignore;
CREATE TABLE t2 (a INT, b INT);
SHOW TABLES;
INSERT INTO t2 VALUES (3,3), (4,4);
SHOW BINLOG EVENTS FROM 102;
sync_slave_with_master;
--echo **** On Slave ****
SHOW DATABASES;
USE test;
SHOW TABLES;
--error 1049
USE test_ignore;

connection master;
DROP DATABASE test_ignore;
sync_slave_with_master;