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