PDA

View Full Version : MySQL Autoincrement after Migration

rmogstad
9th April 2007, 01:23 PM
It seems like doing the migration via Plesk 8.1 causes all of the autoincrement values on my MySQL tables to reset. I start getting duplicate key '0' errors everywhere I have an autoincrement.

Any idea why this might be?
k.satirli
10th April 2007, 02:02 PM
no idea but I can confirm this
jaredfine
7th May 2007, 03:33 PM
It just happened to me after a backup and restore. I am fucking steaming pissed right now.
jaredfine
8th May 2007, 02:32 PM
I've done some research, see my post:

http://forum.swsoft.com/showthread.php?s=&threadid=43750