How did you work out the auto-ids on different servers issue?
Mike
-----Original Message-----
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 2:16 PM
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
---------------------------------------------------------------------
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
