From: Baron Schwartz
Date: September 10 2007 2:00pm
Subject: Re: table based replication into a different db
List-Archive: http://lists.mysql.com/mysql/208986
Message-Id: <46E54E0F.2020100@xaprb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Christian Parpart wrote:
> Hi all,
> 
> i would like to replicate just tables beginning with a certain prefix
> while the replication slave host's database name also differs.
> 
> i remember i once read something about it, but can't really find it on the net 
> anymore, so does anyone have a hint for me here, or even know exactly what 
> needs to be done?

The manual explains it:
http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html
http://dev.mysql.com/doc/refman/5.0/en/replication-options.html

I think you need a combination of do/ignore and rewrite rules.

But read *carefully* because a lot of the replicate-XYZ rules don't do 
what they seem to, in subtle ways that depend on the current default 
database and such.  The manual does explain it, but it takes some deep 
thinking (or at least it took me some deep thinking).

Baron