HI
What effect will this have in my current setup where A is a slave of B and B
is a slave of A.
If A, is correct, and I issue a load on B, when A syncs for an update will
it not try and write those records back?
Thanks'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 05 June 2001 21:16
> To: Warren van der Merwe
> Cc: [EMAIL PROTECTED]
> Subject: Re: Replication out of sync
>
>
> On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der Merwe wrote:
> > Hello
> >
> > Firstly, big thank you to all who helped me get my
> replication going.
> >
> > When I was playing around, I managed to get one of my table out of
> > sync, on the one server I have 8 records and on the other 9. I know
> > exactly what happened, it was when server B was not replicating to
> > the correct address. Now the question is, what is the easiest way
> > of getting them in sync? Do I delete the table from the one server
> > reload it?
>
> Run a LOAD TABLE <table> FROM MASTER on the slave to bring an updated
> copy of the table to the slave.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
>
> MySQL 3.23.29: up 11 days, processed 68,268,148 queries (71/sec. avg)
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
