1include/master-slave.inc 2[connection master] 3connection slave; 4SET @@GLOBAL.replicate_wild_do_table="test.a%"; 5ERROR HY000: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first 6SET @@GLOBAL.replicate_wild_ignore_table="test.b%"; 7ERROR HY000: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first 8connection slave; 9include/stop_slave.inc 10SET @@GLOBAL.replicate_wild_do_table=""; 11SET @@GLOBAL.replicate_wild_ignore_table=""; 12SET @@GLOBAL.replicate_wild_do_table="test.a%"; 13SET @@GLOBAL.replicate_wild_ignore_table="test.b%"; 14include/start_slave.inc 15connection master; 16CREATE TABLE a1 (a INT); 17CREATE TABLE b1 (a INT); 18CREATE TABLE c1 (a INT); 19INSERT INTO a1 VALUES (1); 20INSERT INTO b1 VALUES (2); 21INSERT INTO c1 VALUES (3); 22connection slave; 23SHOW TABLES LIKE '%1'; 24Tables_in_test (%1) 25a1 26connection master; 27connection master; 28DROP TABLE IF EXISTS a1,b1,c1; 29include/rpl_end.inc 30connection slave; 31SET @@GLOBAL.replicate_wild_do_table=""; 32SET @@GLOBAL.replicate_wild_ignore_table=""; 33