Quote Originally Posted by kookiewookie
1062 error ... again.
1062 Duplicate entry '0' for key 1
This will fix that one table:
Code:
ALTER TABLE `subscribers` CHANGE `subscriber_id` `subscriber_id` INT( 11 ) NOT NULL AUTO_INCREMENT
Remember to add your DB prefix if needed.


It meants the auto_increment attribute was dropped from the table. If you chose export compatibility 4.0 you likely dropped the auto_increment value on all your tables-or it does that in mine.

I usually export as 5.0, then edit and change ENGINE to TYPE and edit out any 'charset' settings I might have (needless to say I export the structure and data separately or it takes forever to edit the structure file. :)

You'll want to check your other tables as well to see if any have the autoincrement value. If you fix it piecemeal you may miss some.

-Ng_