From: Claudio Nanni Date: May 2 2012 5:25pm Subject: Re: Can the mysql replication limited to one database List-Archive: http://lists.mysql.com/mysql/227294 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8f22bd89ab772404bf10f87d --e89a8f22bd89ab772404bf10f87d Content-Type: text/plain; charset=ISO-8859-1 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 > 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:CBrown@stripped] > > Sent: Wednesday, May 02, 2012 8:44 AM > > To: Rick James > > Cc: mysql@stripped > > 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 --e89a8f22bd89ab772404bf10f87d--