-->-----Original Message----- -->From: Luc Foisy [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 03, 2003 8:45 AM -->To: MYSQL-List (E-mail) -->Subject: Replication --> --> -->If I have replication already active for a single database ( already -->active between master and slave ) and I want to start replicating a new -->database on the master, what would the correct procedure be? -->I have a dump of the database I want to replicate. Below is the current -->setup for replication. --> -->Master my.cnf -->log-bin -->binlog-do-db=database1 -->server-id=1 --> -->Slave my.cnf -->master-host=master.address -->master-user=replicant2 -->master-password=password -->replicate-do-db=database1 -->server-id=3 --> --> -->Would I just do the following? --> -->Master my.cnf -->binlog-do-db=database2 (then restart master) --> -->load dump into slave db -->Slave my.cnf -->replicate-do-db=database2 (then restart slave)
Sound correct. Just make sure you start the slave at the proper bin log position that the master left off with. --> -->Luc --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
