talkPress 004: Quick WordPress Upgrading

What’s in this episode

• WordPress Upgrading,
• Scripts for Upgrading, Database Backup, Database Restoring,
• and Lots of “blow” hosts. 🙂

Watch it or download it!

You can watch this episode (19m22s) or download .ogg (52.0MB, Theora 15fps/Vorbis 64kbps), .mp4 (MB, H.264 15fps/AAC 64kbps) or .flv (98.9MB, 15fps / 64kbps) on blip.tv. You can also watch this episode on Google Video and Internet Archive.

Preparing to upgrade WordPress to 2.3

Update: Just upgraded to WordPress 2.3.

I think it’s time to prepare for upgrading to WordPress 2.3. Why? First, as we all should already notice that 2.3 has supported tags and those the plun-ins which are related to category will be malfunctioning. If you have activated many plug-ins or you don’t use default or classic theme, you are better to start testing.

There is a great list that could help you to understand what’s going on WordPress 2.3 and a official post for upgrading.

I have a local server for my blog. I used to make modifications on it, then rsync to my remote server which is a public server. So, I don’t need to create additional database or blog on my remote server. Here are the steps that I took for upgrading to 2.3-RC1:

Steps

1. Backup database

mysqldump -u [username] -p [dbname] > wp_backup.sql

There is an option, --add-drop-table, for mysqldump but I think it’s better to completely clean a database. That is deleting and creating a database. Then execute the wp_backup.sql.

You may have MyPHPAdmin, that will be fine if you use it, instead.

Just in case that you have really bad luck: Restore your MySQL database.