607 posts, MySQL, Excel, and some patience

There were 607 posts in this blog with broken links, due to the migration of Spamroll and Thoughtmarket posts over here. I didn’t have existing, running blog platforms with which to apply custom export scripts, so I tooled with raw databases…

  • 517 posts were repaired by extracting their contents using MySQL, and matching link titles with the titles from this WordPress install. The matches were imported into Excel, where concatenation was used to create a long list of UPDATE/REPLACE sql statements. The updates were then run against the database.
  • Of the remaining 90 posts, 75 were modified by hand to replace links that were lost in migration, including links to site search strings and uploaded documents.
  • 13 posts were deleted because broken/missing links were so relevant to the post that not having them made the post useless – most of these were cross links between blogs.
  • Two posts were deleted for personal reasons, having provided me with such extraordinary lessons in human behavior that I no longer wished to share them.

Total time spent on this endeavor was approximately four hours, done mostly in the wee morning when fresh caffeine was still in the bloodstream. All should now be well with internal links here.

PS: All link targets to new windows were also permanently removed (as I know having new windows pop up when clicking web page links has to aggravate more than just myself).

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.