I was moving multiple blogs from one host to another, and one of them is giving an error I am unable to figure out. During the restore of the SQL script through phpMyAdmin, the following error shows up:
VALUES ( 1301, 1096, 'category', '', 12, 1 ) ;
#1062 - Duplicate entry '1301' for key 'PRIMARY'
And all the posts have missing categories and tags.
The 'wp_terms' table has only 2 entries. I tried reading up the Codex entry for database tables and also http://www.cumps.be/nl/blog/read/wordpress-26-upgrade-fix-missing-categories, but not sure whether these are the same problem.