SQL Statements for Controlling Replica Servers This behavior differs from that of the  --replicate-*  filter options where specifying the same option multiple times causes the creation of multiple filter rules. Names of tables and database not containing any special characters need not be quoted. Values used with REPLICATION_WILD_TABLE  and  REPLICATION_WILD_IGNORE_TABLE  are string expressions, possibly containing (special) wildcard characters, and so must be quoted. This is shown in the following example statements: Values used with  REPLICATE_REWRITE_DB  represent  pairs  of database names; each such value must be enclosed in parentheses. The following statement rewrites statements occurring on database  db1  on the source to database  db2  on the replica: The statement just shown contains two sets of parentheses, one enclosing the pair of database names, and the other enclosing the entire list. This is perhaps more easily seen in the following example, which creates two  rewrite-db  rules, one rewriting database  dbA  to  dbB , and one rewriting database  dbC  to dbD : The  CHANGE REPLICATION FILTER  statement replaces replication filtering rules only for the filter types and replication channels affected by the statement, and leaves other rules and channels unchanged. If you want to unset all filters of a given type, set the filter’s value to an explicitly empty list, as shown in this example, which removes all existing  REPLICATE_DO_DB  and  REPLICATE_IGNORE_DB  rules: Setting a filter to empty in this way removes all existing rules, does not create any new ones, and does not restore any rules set at mysqld startup using  --replicate-*  options on the command line or in the configuration file. The  RESET REPLICA | SLAVE ALL  statement removes channel specific replication filters that were set on channels deleted by the statement. When the deleted channel or channels are recreated, any global replication filters specified for the replica are copied to them, and no channel specific replication filters are applied. For more information, see Section 17.2.5, “How Servers Evaluate Replication Filtering Rules” . Caution 13.4.2.3 CHANGE REPLICATION SOURCE TO Statement 2759 CHANGE REPLICATION SOURCE TO  option  [,  option ] ... [  channel_option  ] option : { SOURCE_BIND = ’ interface_name ’ | SOURCE_HOST = ’ host_name ’ | SOURCE_USER = ’ user_name ’ | SOURCE_PASSWORD = ’ password ’ | SOURCE_PORT =  port_num | PRIVILEGE_CHECKS_USER = {’ account ’ | NULL} | REQUIRE_ROW_FORMAT = {0|1} CHANGE REPLICATION FILTER REPLICATE_DO_DB = (), REPLICATE_IGNORE_DB = (); CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB = ((dbA, dbB), (dbC, dbD)); CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB = ((db1, db2)); CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = (’db1.old%’); CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE = (’db1.new%’, ’db2.new%’);