All,
Thanks for your replies and as per the advise I switched to row-based
replication but replication ended with below error.
*Last_Error: Error 'Table 'b.sdefrent' doesn't exist' on query. Default
database: 'b. Query: 'drop table sdefrent'*
above error is due to non existence of database an
> **On master server I have two databases *A and B*. App team use database B
> temporarily for there application to compute calculation and insert the
> values on A database.
For certain statements you could start with "SET SQL_BIN_LOG=0" so it
doesn't log that statement, and it won't be replicat
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 sla
