Press "Enter" to skip to content

Did you miss me?

Well, I’ve finally managed to get my blog up and running again. It appears to have been offline since August of 2021 — at least, that was when the last automated backup arrived in my WPBackups mail folder. To be honest, my shouting-into-the-void needs had largely been met by Twitter (at least until last November), so I wasn’t in much of a hurry to investigate. But it seemed to make sense to self-verify my Mastodon profile, which meant getting this website back online. I took the opportunity to update my Linode instance from Ubuntu 2016.4 LTS to something newer, install the latest WordPress, etc.

It turns out that the plugin I had been using to get those regular backup emails was only sending me the contents of the database as a SQL file, whereas most of the online guides to “restoring” or “migrating” a WordPress site assume you have an XML-based export file. After a couple of false starts, I found this article which had the key to success: namely to create a new database and populate it from the SQL file, then install WordPress and point it at that database during the “five-minute install” process. At this point WordPress will say “You appear to have already installed WordPress; let me just bring your database up to date” and then you’re ready to go, more or less.

(I got an immediate error that included the name of the theme I had forgotten I was using. Reinstalling that was much more pleasant than trying to get something I liked out of the default WP themes that are based around the WP block editor, which seems like overkill for a simple text blog.)

Now that I’ve done all that, will I begin blogging regularly again? We’ll see; if so, it will likely be more articles on macOS and Swift programming, and fewer hot takes on hot button issues (which frankly I don’t have the energy to deal with these days).

2 Comments

  1. M. Finn
    M. Finn January 23, 2023

    I love a blog post dense with tech speak; there’s something hot about a man who knows his way around a keyboard.

    • Russell Finn
      Russell Finn January 23, 2023

      Watch it, now; you’ll frighten the horses.

Leave a Reply

Your email address will not be published. Required fields are marked *