I was migrating a simple MySQL database from my PC to my Web server.
I was stuck when I could not add records to my table . MySQl threw a duplicate value for primary key error.
I was able to add records to my table in the local database in my PC though.
When I compared the two tables side by side , I found the auto_increment property missing in the remote table.
 remote table mysql 4.1.21
 local table mysql 5.0.27-community-nt
Further investigation proved that the real culprit is PhpMyAdmin.
When you export a table along with the SQL compatiblity mode set to Mysql 4, it chops the auto_increment property.
Need to find a workaround for this, Or is it time to revert back to Mysql 4.1 on local or look of a Mysql 5.0 host
