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) Luc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]