Hi --replicate-wild-do-table=db_name.tbl_name replicates only updates that use the specified table in the given database. If any wild cald patterns specified, then match the specified database and table name patterns. Tells the slave thread to restrict replication to statements where any of the updated tables match the specified database and table name patterns.
--replicate-wild-ignore-table=db_name.tbl_name Tells the slave thread not to replicate a statement where any table matches the given wildcard pattern. So to replicate only the merge_t table, try a) set-variable = binlog-do-db=DatabaseB set-variable = replicate-wild-do-table=DatabaseB.merge_t or to replicate all the tables except merge_t b) set-variable = binlog-do-db=DatabaseB set-variable = replicate-wild-do-table=DatabaseB.% set-variable = replicate-wild-ignore-table=DatabaseB.merge_t Ref: http://www.mysqlpress.com/doc/refman/5.0/en/replication-options.html Thanks ViSolve DB Team. ----- Original Message ----- From: "Eric Anderson" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Friday, October 06, 2006 4:15 AM Subject: Replication > > I'm having a problem with my replication settings in my.cnf. I know > it's probably something stupid. > > I've got an existing database configured to replicate as follows: > > set-variable = binlog-do-db=DatabaseA > set-variable = replicate-do-table=DatabaseA.foo_t > > and that replicates that one single table just fine. > > I'm trying to replicate a single table from another database: > > set-variable = binlog-do-db=DatabaseB > set-variable = replicate-do-table=DatabaseB.bar_t > > but nothing gets replicated. There is a MRG table in DatabaseB though, > but adding the following: > > set-variable = binlog-do-db=DatabaseB > set-variable = replicate-do-table=DatabaseB.bar_t > set-variable = replicate-ignore-table=DatabaseB.merge_t > > doesn't help. The following works though: > > set-variable = binlog-do-db=DatabaseB > set-variable = replicate-wild-do-table=DatabaseB.% > set-variable = replicate-ignore-table=DatabaseB.merge_t > > but that replicates all tables except for the MRG table and I'd rather > not replicate all the tables. Any ideas? > > -- > > WANT TO MODEL FOR MAC & BUMBLE? APPLY AT http://casting.macandbumble.com > ------------------------------------------------------------------------- > Eric Anderson Mac and Bumble Bumble Cash > ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com > San Diego, CA <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> > ------------------------------------------------------------------------- > SEE OUR LATEST PARTY PICTURES -- http://events.macandbumble.com/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
