I recommend to use the 'wild' modifier, if you have a default db and you specify the schema in the query like update schemanotreplicated.mytable..... you will miss that.
Claudio 2012/5/2 Rick James <rja...@yahoo-inc.com> > Yes, doable. In my.cnf on master: > Binlog-do-database = dbname1 > Binlog-do-database = dbname2 > Would replicate those two dbs only. > There are many other combinations using > binlog/replicate-do/ignore-db/table/wild. See the manual on replication, > and especially the flowchart on how those interact (sometimes in unexpected > ways). > > > -----Original Message----- > > From: Brown, Charles [mailto:cbr...@bmi.com] > > Sent: Wednesday, May 02, 2012 8:44 AM > > To: Rick James > > Cc: mysql@lists.mysql.com > > Subject: Can the mysql replication limited to one database > > > > Hi Gurus, > > > > Can the mysql replication limited to selected schema or database? I've > > been asked to set up mysql for only 1 out 5 databases exist in > > production. Please advise if this is doable > > > > Thanks > > > > ******************************************** > > This message is intended only for the use of the Addressee and may > > contain information that is PRIVILEGED and CONFIDENTIAL. > > > > If you are not the intended recipient, you are hereby notified that any > > dissemination of this communication is strictly prohibited. > > > > If you have received this communication in error, please erase all > > copies of the message and its attachments and notify us immediately. > > > > Thank you. > > ******************************************** > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- Claudio
