Re: Auto Increment field duplicate key ...

2002-02-12 Thread Hank Marquardt
2 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

Auto Increment field duplicate key ...

2002-02-12 Thread Hank Marquardt
ng 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 a

Re: Auto Increment field duplicate key ...

2002-02-09 Thread Hank Marquardt
2 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

Auto Increment field duplicate key ...

2002-02-09 Thread Hank Marquardt
ng 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 a

Re: Newbie Questions

2001-07-14 Thread Hank Marquardt
t; > 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 Web & Database Development in