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" <eric@stripped>
To: <mysql@stripped>
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 <eric@stripped> <eric@stripped>
> -------------------------------------------------------------------------
> 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/mysql?unsub=1
>
