Hello World!

Suddenly Gigahost fuxed up my webserver and then all my files were gone. Then I cried for a while, in my mind, and then I set to work restoring my site.

Luckily, my database was still intact so I could recover all my posts and comments but it did take a bit of fiddling. I couldn’t copy over my user info or my options because then WordPress broke, but that isn’t that big of a deal because I only have one user anyway.

This is what I did to use my old database in my new WordPress install and you could probably too if you use phpMyAdmin:

  1. Install a fresh wordpress to a new database, run the install script and log in to the new database
  2. I added myself as a new user and deleted the admin, but I don’t think this is necessary.
  3. Go to phpMyAdmin and select your old data base.

You need to copy the following tables: wp_comments, wp_links, wp_posts, wp_postmeta, wp_terms, wp_term_relationships and wp_term_taxonomy. That were the tables I bothered copying, at least. You do that by doing the following:

  1. Select one of the tables in the list to the left and then click the operations tap on the right of the list
  2. In the “Copy table to (database.table)” select your new database and type in the name of the table (or copy it from the “Move table to” field right above your current field.
  3. click the “add DROP TABLE” option.
  4. click “Go”
  5. Hopefully you didn’t get any errors or you are now, officially, in Trouble.

You should now have a working wordpress with all your old posts and none of your old design. Take it as an opportunity to spice up your website a bit. Also, take this opportunity to backup your website. I know I will.

Movable Mess

That is, my site will be in a temporary state of moving mess. It might last as long as the rest of the year. I had originally planned to leave my old blog in place until I had this one ready to go, but I am reasonable sure that would only make the move take even longer and until I finished my main blog would be completely dead. Granted, that wouldn’t make it much different from what has been going on (or not, as it may be) for the last three months. And so, since my move to wordpress had been so easy so far, I decided to just go ahead and do it.

They should make that a catchphrase. Just do it!