Support » Fixing WordPress » Problem: Backup and restored database, and now doesn’t work!

  • Recently, I had backuped my whole database using mysql dump. I have moved to a diferent mysql server, and have restored the database. Now, whenever i try to post, it tries to post to ID 0 in the database. so therefore i get this:

    WordPress database error: [Duplicate entry ‘0’ for key 1]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘0′,’_pingme’,’1′)

    WordPress database error: [Duplicate entry ‘0’ for key 1]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘0′,’_encloseme’,’1′)

    How can I fix this? Please? It seems like the ID counter resetting to zero. How can i get it to go back to its normal number?

  • The topic ‘Problem: Backup and restored database, and now doesn’t work!’ is closed to new replies.