rpl_ignore_db is case sensitive while rpl_ignore_table is not case sensitive

--replicate_ignore_db=IgNORE_Db --replicate_ignore_table=ignore_tABLe.TablE1

--source include/master-slave.inc

--connection master

--echo #replicate_ignore_db

create database ignore_db;

--echo #replicate_ignore_table

create database ignore_table;

use ignore_table;

create table table1(a char);

--sync_slave_with_master

show databases;

use ignore_table;

show tables;

--connection master

drop database ignore_db;

drop database ignore_table;

--source include/rpl_end.inc

include/master-slave.inc

[connection master]

#replicate_ignore_db

create database ignore_db;

#replicate_ignore_table

create database ignore_table;

use ignore_table;

create table table1(a char);

show databases;

Database

information_schema

ignore_db

ignore_table

mtr

mysql

performance_schema

test

use ignore_table;

show tables;

Tables_in_ignore_table

drop database ignore_db;

drop database ignore_table;

include/rpl_end.inc