Hi
Well, what I did was dump my structure to file, then I went an manually
added a line to the end of each table saying "AUTO_INCREMENT=100000000" for
Site A, Site B was set to 200000000 and so on, obviously there is a chance
one day of Site A's auto_increment reaching 200000000 but it won't happen
for many many many years in my environment.
Regards
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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: Michael Eklund [mailto:[EMAIL PROTECTED]]
> Sent: 05 June 2001 23:18
> To: [EMAIL PROTECTED]; 'Warren van der Merwe'
> Subject: RE: Replication out of sync
>
>
> 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
