From: Johan De Meersman Date: January 27 2011 9:53am Subject: Re: Replication Error on Slave List-Archive: http://lists.mysql.com/mysql/224239 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015174c16e6da27ee049ad0eb4a --0015174c16e6da27ee049ad0eb4a Content-Type: text/plain; charset=ISO-8859-1 On Thu, Jan 27, 2011 at 10:40 AM, Nagaraj S wrote: > **On Slave Server I replicate database *A alone* and my replication not > working due to data fetching happen on B database. > Well, yes. Statement-based replication does what it says on the box: it executes the exact same statement on the slave. If database B is not there, then insert into A select from B will not work. You may switch to row-based replication (which of course has it's own caveats, see the online manuals); or you can simply choose to also replicate database B. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0015174c16e6da27ee049ad0eb4a--