No, I don't do such things, the 'replication' means only that I download
from an other machine some text files, with e-mail addresses and insert
them into the table. So no id nor other fields are replicated, just the
email field from a text file. (a perl script reads and inserts them).
The strange thing is that after a full backup-reload procedure (cca.8000
records, max(id)~550.000)
the table dies on an INSERT or a CHECK TABLE command.
Norbert Molnar
Gerald Clark wrote:
>
> If you are using 'replication', and trying to do bi-directional
> replication, you will ( unless you are very careful ) have this problem.
> The auto increment id is passed with the rest of the data to the slave.
> If you are inserting on both masters and each assigns the same id, the
> replication will fail with duplicate autoincrement ids.
>
---------------------------------------------------------------------
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
