Just for further puzzlement -- I've run 'check table extended' on the table, dropped the table and reloaded it, shut down the server and restarted it ... all to the same effect. First insert to the table is the 214... integer limit then duplicate key errors.
On Sat, Feb 09, 2002 at 11:18:08AM -0600, Hank Marquardt wrote: > I moved a database from one server to another (mysqldump -> mysql dbname > < filefromump) ... and on the new server one table that has an auto > increment index fails with duplicate keys after the first insert ... the > first insert as an integer bound value (2147483647) rather than using > the established sequence (which was at 512 on the old server) ... how > can I fix this (and what caused it) ... if I 'describe' the table it > shows properly as an auto_increment integer. > > I did a couple quick searches but didn't find anyone with the same > problem ... weird. Any and all help appreciated. > > -- > Hank Marquardt <[EMAIL PROTECTED]> > http://web.yerpso.net > GPG Id: 2BB5E60C > Fingerprint: D807 61BC FD18 370A AC1D 3EDF 2BF9 8A2D 2BB5 E60C > > --------------------------------------------------------------------- > 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 > -- Hank Marquardt <[EMAIL PROTECTED]> http://web.yerpso.net GPG Id: 2BB5E60C Fingerprint: D807 61BC FD18 370A AC1D 3EDF 2BF9 8A2D 2BB5 E60C *** Web Development: PHP, MySQL/PgSQL - Network Admin: Debian/FreeBSD *** PHP Instructor - Intnl. Webmasters Assn./HTML Writers Guild *** Beginning PHP -- Starts January 7, 2002 *** See http://www.hwg.org/services/classes --------------------------------------------------------------------- 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
