PLANOS DE SAÚDE PARA VOCÊ OU PARA SUA EMPRESA

2011-01-27 Thread Paulo 

Seu cliente de e-mail não pode ler este e-mail.
Para visualizá-lo on-line, por favor, clique aqui:
http://www.ps-mkt.com/emailer/display.php?M=259&C=10a817f92e8d8a7838d6001dda9522d0&S=11&L=6&N=3


Para parar de receber nossos
e-mails:http://www.ps-mkt.com/emailer/unsubscribe.php?M=259&C=10a817f92e8d8a7838d6001dda9522d0&L=6&N=11

Re: Replication Error on Slave

2011-01-27 Thread Johan De Meersman 
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

Replication Error on Slave

2011-01-27 Thread Nagaraj S 
I have setup mysql replication with below scenario



**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.



**On Slave Server I replicate database *A alone* and my replication not
working due to data fetching happen on B database.


Kindly help me out to resolve this issue.

-Naga