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?

Thanks in advance,
Christian Parpart.

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/...ion-rules.html
http://dev.mysql.com/doc/refman/5.0/...n-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