Edit File: rpl_ignore_table_update.test
# This one assumes we are ignoring updates on table mysqltest_foo, but doing # the ones on all other tables source include/master-slave.inc; connection slave; # # For this test we must be in the test database # use test; --disable_warnings drop table if exists mysqltest_foo; drop table if exists mysqltest_bar; --enable_warnings create table mysqltest_foo (n int); insert into mysqltest_foo values(4); connection master; use test; create table mysqltest_foo (n int); insert into mysqltest_foo values(5); create table mysqltest_bar (m int); insert into mysqltest_bar values(15); create table t1 (k int); insert into t1 values(55); save_master_pos; connection slave; sync_with_master; select mysqltest_foo.n,mysqltest_bar.m,t1.k from mysqltest_foo,mysqltest_bar,t1; connection master; drop table mysqltest_foo,mysqltest_bar,t1; save_master_pos; connection slave; sync_with_master; drop table mysqltest_foo,mysqltest_bar,t1; # End of 4.1 tests
Back to File Manager