RE: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-03 Thread Brown, Charles
...@bmi.commailto:cbr...@bmi.com To: Nitin Mehta ntn...@yahoo.commailto:ntn...@yahoo.com Sent: Thursday, May 3, 2012 9:27 AM Subject: RE: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Nitin, Help Me! Using your approach, do I have to put anything

Re: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-03 Thread Nitin Mehta
, 2012 3:17 PM Subject: RE: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Nitin, Please give Nitin a prize. What a quiet genius she is. Now, I get it. Now, I can see clearly. I’ve tried it and it worked. Thanks so much. From: Nitin Mehta

RE: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-03 Thread Rick James
. -Original Message- From: Nitin Mehta [mailto:ntn...@yahoo.com] Sent: Wednesday, May 02, 2012 9:25 PM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: using the bin-log approach on the master side, how can I accomplish my replication objectives Hi Charles, I believe you

Re: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-02 Thread Nitin Mehta
I guess, it only makes things even more simple.   You should use replicate-do-table=db1.tb1 and so one in slave's cnf to ensure that only this particular table gets replicated. However, all the databases on master will get bin-logged and you may or may not want to do that.   So making it even

Re: using the bin-log approach on the master side, how can I accomplish my replication objectives

2012-05-02 Thread Nitin Mehta
: Thursday, May 3, 2012 9:27 AM Subject: RE: using the bin-log approach on the master side, how can I accomplish my replication objectives Hello Nitin, Help Me!  Using your approach, do I have to put anything on  the master “my.cnf”.   Thanks     From:Nitin Mehta [mailto:ntn...@yahoo.com] Sent