bruce wrote:
> hi...
>
> a quick question that i haven't found an answer to.
>
> i can use "replicate-do-db=foo" in a my.cnf file for replication, to
> replicate the master foo db on the slave. but this requires that i use/have
> a my.cnf set on the slave.
>
> is there a way to dynamically set this attribute/parameter within mysql on
> the fly. i thought it would be possible via "change master to" but didn't
> find the cmd when looking through the mysql information.
>
> basically, i'm going to have multiple databases, on multiple systems, that
> i'm going to be replicating to a single system. so, for each master server,
> i'd like to be able to set the databases that i'm going to replicate...
>
> thanks
>
>
>
Can't do that currently in MySQL. It is called multi-master
replication. You can do multi-slave replication which replicates from
one master to multiple slaves, but not the other way around.

Keith