MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Replication of some tables (not whole database). Possible?
Posted by: Thomas CORBIERE
Date: November 05, 2005 11:49AM

you can replicate some tables with this option in your slave configuration file :
replicate-do-table=db_name.tbl_name

From mysql manual : "Tells the slave thread to restrict replication to the specified table. To specify more than one table, use this option multiple times, once for each table."

Thomas CORBIERE

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Replication of some tables (not whole database). Possible?
2664
Dean C.
November 03, 2005 10:15AM
Re: Replication of some tables (not whole database). Possible?
2203
Dean C.
November 05, 2005 08:23AM
Re: Replication of some tables (not whole database). Possible?
2247
Thomas CORBIERE
November 05, 2005 11:49AM
Re: Replication of some tables (not whole database). Possible?
2269
Dean C.
November 05, 2005 12:20PM
Re: Replication of some tables (not whole database). Possible?
2985
Thomas CORBIERE
November 05, 2005 01:45PM


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.