If anyone paid attention, my blog was down for a couple of hours as I upgraded to WordPress 2.3 from my current WordPress 2.2.3. Technically it should have been a standard upgrade without the fuss. After all, I have been doing this for years every since the age old WordPress 1.3 and there should have been no surprises. Unfortunately, this is what happened.
- Downloaded WordPress 2.3
- Backed up my database with the database backup plugin.
- Uploaded all the WordPress 2.3 files via FTP.
- Ran upgrade script.
- Opened the main page to find “database wp_categories not found” plastered all over my blog.
- Realised there must have been a problem.
- Opened Gmail to find my backups.
- Found out they weren’t there.
- Searched Gmail again.
- Panicked more.
- Uploaded WordPress 2.2.3 in a futile attempt to repair the database.
- Found out it was a silly idea.
- Kept panicking.
- Calmed down enough to check if the backups were sent from the server.
- Found out they were stuck on my server, never sent even though I scheduled them to do so
- Uploaded the pre-upgrade backup.
- Found out that they didn’t contain my tags which have been deleted.
- Panicked but not to the extent of the last panic.
- Found out that the last backup didn’t contain optional details.
- Uploaded a week old backup which did contain optional details.
- Realised I forgot to upload my wp-config.php with server details.
- Spent 15 minutes entering all the wrong username, database name and password before remembering I backed that up on my hard drive a while back.
- Restored my blog to the original WordPress 2.2.3 with everything intact.
It’s fair to say that backing up your blog, no matter who you are or what the situation is important. It goes to say that even if you’re an age old veteran around your blog, you’re never too careful when it comes to updating to a new version. More so when your blog contains a lot of hacks and custom elements.
That being said, I did find out why I couldn’t upgrade in the first place, thanks to a quick pointer from the folks at the #Wordpress IRC channel. My theme still uses the “wp_catagories” to pull the posts. Some plugins probably use those databases as well. Things which have otherwise been removed from the new WordPress 2.3. I can’t upgrade until I’ve edited the core parts of theme to go along with the new changes. A pain, since I barely have time to look into it in the first place, but that’s the way the wheel turns in this case.
Either way, upgrading should be a snap for those people that aren’t so fiddly with their WordPress blogs. Just remember to back up and you’re all set. Upgrading for me on the other hand is going to take time which means I have to tweak the bulk of it in my Sandbox. The problem is when I’m actually free to start tinkering with the theme.
How does the year 2010 sound?