Gary Thornock's Weblog

The WordPress people have released WordPress version 2.0.1. I've decided to go ahead and upgrade this site. (I skipped the 2.0 upgrade a month ago, due to some issues I ran into when I tried it in my non-public test environment.)

One note for people thinking about doing the upgrade: if you're like me, you have two separate MySQL user accounts set up: one for administration, and one with far more restrictive permissions for the WordPress application to use. This is generally a good security practice. It will, however, cause problems during the upgrade. I recommend that, before you run upgrade.php (step 9 in the upgrade instructions), you edit wp-config.php, comment out the lines about the restricted database user, and replace them temporarily with the administrative user account. Failure to do this will result in corruption of your WordPress database, as the upgrade will only partially fail. At that point, your best, and perhaps only, recovery option is to restore the backup that you made in step 1. Once the upgrade is finished, of course, go ahead and switch back to the restricted database user for regular site operation.