MySQL Forums
Forum List  »  Replication

Re: Replecation of just 1 or 2 databases onto a slave
Posted by: Claudio Paganelli
Date: July 15, 2005 08:53AM

Hi Lonnie,
if I've got your issue, to replicate only few db from MASTER to SLAVE do the following.

On SLAVE server put the line "replicate-do-db=dbname" in my.cnf (under [mysqld] group) file to tell the server to get only "dbname" instead the whole DBs. Obviously, stop and start the SLAVE and restart mysql server daemons.

Hope this help,
Regards.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Replecation of just 1 or 2 databases onto a slave
1735
July 15, 2005 08:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.