Debian Codegraph @

mysql-test/suite/rpl/t/rpl_replicate_ignore_db.test

raw
1 # see if --replicate-ignore-db works
2
3 --source include/master-slave.inc
4
5 --disable_warnings
6 drop database if exists mysqltest1;
7 drop database if exists mysqltest2;
8 --enable_warnings
9 create database mysqltest1;
10 create database mysqltest2;
11
12 use mysqltest1;
13 create table t1 (a int);
14 insert into t1 values(1);
15 sync_slave_with_master;
16 --error 1146
17 select * from mysqltest1.t1;
18
19 connection master;
20 use mysqltest2;
21 create table t1 (a int);
22 insert into t1 values(1);
23 sync_slave_with_master;
24 select * from mysqltest2.t1;
25
26 # cleanup
27 connection master;
28 drop database mysqltest1;
29 drop database mysqltest2;
30 sync_slave_with_master;
31 --source include/rpl_end.inc