Re: Can the mysql replication limited to one database

[a.smith]

Quoting "Brown, Charles" <CBrown@stripped>:


> Can the mysql replication limited to selected schema or database?

Hi, yes it can. On the master side you control what is written to the  
binlog with my.cnf entries for each DB like:

binlog-do-db=DB1
binlog-do-db=DB2

And on the slave side you use entries like:

replicate-do-db=DB1
replicate-do-db=DB2

thanks Andy.