Re: Replicating only a certain database
Posted by:
Rick James
Date: November 22, 2013 11:50PM
> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com';
is the proper way. To replicate only one database, use
binlog-do-db = livedatabase
in my.cnf (my.ini) of the master. Also restart the master.
To do the revoke, etc, first do STOP SLAVE (on the slave); do START SLAVE afterwards.
Subject
Views
Written By
Posted
1633
November 21, 2013 02:56AM
Re: Replicating only a certain database
854
November 22, 2013 11:50PM
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.