WordPress Upgrade Issues

So I was upgrading WordPress for a client today, going from version 2.1.1 to 2.3. I uploaded the files, ran the upgrade script and got a bunch of errors. Apparently I had forgotten to give the database user more access than just select, insert and update; the update had to create a few tables.So I went back, edit the database user and gave them full access to the database. I went to run the upgrade script again and it said my database was up to date. Looking at the public blog, I just got a bunch of MySQL errors about the wp_terms table gone missing. Great…So, looking into this further I found how to fix it:

1.  Change the “db_version” to 3441, which is the version for 2.0.
2. Re-run the database update script (making sure to have full access for the db user)

All in all, that fixed it!