I've been doing quite a bit of maintenance work on the site recently, updating to the latest version of WordPress, removing old unwanted plug-ins, updating plug-ins I do use, and the like. Today I went into the database for the site and noticed some old tables from uninstalled plug-ins that were still present. In my haste to remove them I made a cardinal sin. I forgot to backup the database first. Clearly stupid I know. I had accidentally deleted a table that references the posts to categories and the last backup I had was from August 4th. This backup was before the WordPress update and a bunch of posts & a few comments from last week have been lost. I was able to save the couple of posts from today and Friday (I had browser windows open to the text that let me copy and paste them back), but the 3 posts on an open source compression application and baby updates.
To catch you up on what I deleted I'm going to summarize:
- Kris had 2 ultrasounds last week. Baby girl was in the wrong position to get a good look at her spine so the second scan was needed.
- 7-Zip is an open source application that I have used for a few months with great success. It compresses/decompresses data quickly, into small archives and can open almost any of the popular compression formats.
Of course the originals were written with great eloquence and wit. Let this be a lesson to you all, backup your data.
