Restoring after update failed. Duplicate entry.
-
I’m new to WP and MySQL. I accepted the advice to update to the latest version and also followed the advice for backing up successfully. Now the site displays as it was before the backup and posts and changes have been lost. I then followed the advice below for restoring from backup.
Restoring Your Database From Backup
Across the top of the screen will be a row of tabs. Click the Import tab.
On the next screen will be a location of text file box, and next to that a button named Browse.
Click Browse. Locate the backup file stored on your computer.
Make sure SQL is selected in the Format drop-down menu.
Click the Go button.//
I was surprised the advice did not provide for UPDATE or restoring the data so I was not surprised to receive the msg
MySQL said: Documentation
#1062 – Duplicate entry ‘1’ for key ‘PRIMARY’//
I could just go back over the site, re-post and re-implement the changes but I would have the same problem next time I updated. I’ve searched the help files extensively and cannot find an instance of this particular problem. I’m reluctant to delete the databases with so little experience and would prefer to amend the backup by changing the INSET INTO in each instance but I don’t know what syntax to use. I tried UPDATE on its own, UPDATE INTO but now I am seeking professional help instead.
Any other suggestion would be most welcome and perhaps the RESTORING instructions could be amended to help dummies like me.
- The topic ‘Restoring after update failed. Duplicate entry.’ is closed to new replies.