From: Date: January 28 2004 4:39pm
Subject: Re: updates on slave server??
List-Archive: http://lists.mysql.com/mysql/158542
Message-Id: <Law12-F125SI1TlbzX7000378e7@hotmail.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed

Is there a way to check that data on slave server is the same as data on 
master ?

Thanks



>From: Paul DuBois <paul@stripped>
>To: "Mike Mapsnac" <mikerh9@stripped>, mysql@stripped
>Subject: Re: updates on slave server??
>Date: Mon, 26 Jan 2004 21:58:42 -0600
>
>At 0:49 +0000 1/27/04, Mike Mapsnac wrote:
>>Hello
>>
>>I found today that some data on slave server were different than on master 
>>server. I don’t know how that can happen. Slave server was running, "show 
>>slave statu"s show no errors
>>
>>If I make some updates on slave server. Does this updates will be 
>>reflected on
>>master server? Or slave cannot synchronize master server?
>
>You're not supposed to update the slave server, except by means of updates
>from the master.  Updates go from master to slave, not the other way 
>around.
>
>
>--
>Paul DuBois, MySQL Documentation Team
>Madison, Wisconsin, USA
>MySQL AB, www.mysql.com
>
>MySQL Users Conference: April 14-16, 2004
>http://www.mysql.com/uc2004/

_________________________________________________________________
Learn how to choose, serve, and enjoy wine at Wine @ MSN. 
http://wine.msn.com/