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.
- Panicked.
- 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?
9rules Member
Entry Details:
Quick Asides:
Reader Polls
Subscribe:
Most Recent Posts:
Recent Comments:
Recent Readers:




4 Trackback and Pingbacks: »
[...] I thought the schema changes would kill my blog. I even created a testbed to test if the upgrades will work smoothly. I tried running the upgrades on the testbed. Everything works fine. Not as dramatic as Edrei’s case [...]
[...] Diary Of An Attempted WordPress 2.3 Update (Footsteps in the Mirror) [...]
[...] Kamigoroshi: Diary Of An Attempted WordPress 2.3 Update [...]
[...] never too early to do a backup. Without a proper backup, panic attack won’t help our penguin here. If you are more adventurous, you can check out this DB Manager plugin which promises more [...]
11 People Said A Couple Of Things: »
2015?
Comment Permalink
OK, now I think I need to search for a very detailed instructions to upgrade my blog (or I could try it with my sister’s blog first, LOL). You know how I always tremble throughout the process…
Comment Permalink
Pat: Yeah, probably around there.
Pelf: It’s not that hard. It’s just like what you did last time. Mine’s just iffy because I have way too many plugins to maintain as well. You don’t have much, which is alright. I say go ahead with it. I guarantee you won’t have any problems.
Comment Permalink
How about next time you upgrade under the influence of alchohol? Pumps up your gut one way or another.
Comment Permalink
Forget 2010! Move over to Blogger!
Mwahaha…
Comment Permalink
This is good to know. I really want to do it, if only for the way it works with tags but I know I’m going to have to do some major tweaking with my theme. I think that I’ll wait just that little bit longer.
Comment Permalink
Cirnelle: Why would I want to pump up my gut again?
ChickyBabe: No way I’m returning to Blogger. I keep telling you it doesn’t give me all the power I want over my blog.
Cerebralmum: Yeah, you might want to just to make sure all the plugins you’re using and theme is compatible with the new format. It’s not that important as of yet. Just more things to play with than actual fixes. Nothing you can’t hold off till you really need to.
Comment Permalink
Haha… mine is still using an old version. Very lazy these days… you help me upgrade can or not?
Comment Permalink
Well, I’m sorry you had trouble upgrading… but I’m glad that I wasn’t the only one who did!
Comment Permalink
Did you finally manage to update, or is it still on the old version?
Comment Permalink
Andoo: It’s updated alright. Everything is working just fine.
Comment Permalink
Leave a Comment