Replicate-wild-do-table and Replicate-wild-ignore-table

• --replicate-wild-do-table=db_name.tbl_name

  < Span class= "bold" > command-line Format
  Permitted Values	Type	string

  Creates a replication filter by telling the slave thread to restrict replication to statements where any of the updated TA Bles match the specified database and table name patterns. Patterns can contain the" % "and" _ "Wildcard characters, which has the same meaning as for theLIKEPattern-matching operator. To specify more than one table, use the This option multiple times, once for each table. This works for cross-database updates.

  constrains Any statements related to update tables that match the specified database and table names by telling the thread to create a replication filter. Patterns can contain "%" and "_" wildcard characters, which are similar to pattern matching algorithms. To specify more than one table, use this option multiple times for each table. This is the work of cross-database updates.

  Cross-database This is the point, unlike Replicate-do-db, other library operations, will not synchronize the set of libraries. This parameter, as long as the table involved, will be synchronized.
  

  
  

• --replicate-wild-ignore-table=db_name.tbl_name

  Command-Line Format	--replicate-wild-ignore-table=name
  Permitted Values	Type	string

  Creates a replication filter which keeps the slave thread from replicating a statement on which any table matches the give n wildcard pattern. To specify the than one table to ignore, use the this option multiple times, and once for each table. This works for cross-database updates.

Replicate-wild-do-table and Replicate-wild-ignore-table