There’s a saying in the IT world: “If it ain’t broke, don’t fix it!” or perhaps that’s just the advice my Dad gave me.<\/p>\n
Either way, I failed to follow that advice and things have gone wrong. An innocuous little tweak has ended up with over half of the posts on this site disappearing.<\/p>\n
Oddly (or typically if you work in IT) reversing the very small change I made does not seem to solve the problem, which is a major pain.<\/p>\n
Not to worry, I do at least take regular backups of this site, so it should just be a matter of restoring from the backup immediately prior to the change I’d made. Unfortunately, nothing in IT is ever that simple. I kept getting WordPress backup import restore errors like this:<\/p>\n
> Duplicate entry ‘15878’ for key ‘PRIMARY’<\/strong><\/p>\n For some reason the backups I took duplicated many of the comment records, actually in the .sql.gz backup file. I have no idea why this happened, but I had to manually remove the duplicates by deleting one of the offending duplicate INSERT sql statements. Here’s an example of an offending line (email address changed):<\/p>\n \tINSERT INTO `wp_comments` VALUES (15878, 192, ‘Eric’, ‘eric@eric.com’, ‘Eric’s comment was here’, 0, ‘1’, ‘Mozilla\/5.0 (Windows NT 6.1; rv:10.0.2) Gecko\/20100101 Firefox\/10.0.2’, ”, 0, 0, ‘N’, ‘0’); <\/p>\n The really annoying thing was that there’s no way to tell which comments were duplicated without just trying to do the import. This was the process I had to follow, on the database’s Import tab in phpMyAdmin from the cPanel:<\/p>\n – Select the .sql.gz backup file for import That’s it, for each duplicate, of which there were over 10!<\/p>\n Anyway, the long point of this post is that if you posted a comment on this bloc between 22nd May and 23rd June, it’s probably gone. I’m very sorry about that<\/strong>, as I do appreciate and read every comment that’s posted. Please re-post it.<\/p>\n","protected":false},"excerpt":{"rendered":" There’s a saying in the IT world: “If it ain’t broke, don’t fix it!” or perhaps that’s just the advice my Dad gave me. Either way, I failed to follow that advice and things have gone wrong. An innocuous little tweak has ended up with over half of the posts on this site disappearing. Oddly […]<\/p>\n","protected":false},"author":161,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[342,344,343,10],"class_list":{"0":"post-3085","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-uncategorized","7":"tag-backup","8":"tag-error","9":"tag-restore","10":"tag-wordpress"},"_links":{"self":[{"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/posts\/3085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/users\/161"}],"replies":[{"embeddable":true,"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/comments?post=3085"}],"version-history":[{"count":2,"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/posts\/3085\/revisions"}],"predecessor-version":[{"id":3088,"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/posts\/3085\/revisions\/3088"}],"wp:attachment":[{"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/media?parent=3085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/categories?post=3085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.colinmcnulty.com\/blog\/wp-json\/wp\/v2\/tags?post=3085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n– Click GO
\n– Wait for it to upload and start the import
\n– Check the error for the primary key number it was moaning about.
\n– Unzip the .gz file to get the .sql
\n– Edit the .sql file and search for the offending primary key number
\n– Delete one of the duplicates
\n– Save the .sql file
\n– Find the .sql file in Windows Explorer and zip it up, ensuring it’s .gzip format
\n– Repeat the import process <\/p>\n