The FAQ, How do you force a database upgrade? will help you with that though you might also consider restoring your 2.0 (or 2.1) database, then go from there.
Resource:
Restoring_Your_Database_From_Backup
Upgrading WordPress Extended
I don’t understand from that link where to change that value in options.php ?
Also it mentions you can change it in myPHPadmin which you can’t.
I don’t understand what you mean restore your 2.0 or 2.1 database, I have it still in good condition!!!
You would use phpMyAdmin to change the value of db_version in the wp_options table, then do the upgrade.php process again.
As for your 2.0/2.1 database, I was suggesting that you might want to restore that version of your database and then do the upgrade again.
Alright I did as you said but I got these errors:
WordPress database error: [Table ‘blog.wp_categories’ doesn’t exist]
SELECT * FROM wp_categories ORDER BY cat_ID
WordPress database error: [Table ‘blog.wp_post2cat’ doesn’t exist]
SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id
WordPress database error: [Table ‘blog.wp_linkcategories’ doesn’t exist]
SELECT cat_id, cat_name FROM wp_linkcategories
Upgrade Complete
Your WordPress database has been successfully upgraded!
My old database still did not migrate ??
These tables (wp_categories, wp_post2cat, wp_linkcategories) no longer exist in the newer versions of WordPress, but old plugins and themes may still use them. Did you disable all plugins before upgrading?
http://codex.wordpress.org/Database_Description
No I couldn’t my wordpress got hacked ! So can I fix this?
If you can’t disable plugins, then use ftp to delete them out of the plugins folder before upgrading.
No Upgrade Required
Your WordPress database is already up-to-date!
After deleting the plugins I get this error when I try to upgrade, yet my old MySQL database still did not migrate, but I did back up the database so can I fix it still?
No Upgrade Required
Your WordPress database is already up-to-date!
It sounds like your database was updated. If not, try switching to the default theme before trying to upgrade. Save a backup copy of your current theme before deleting it via ftp. Make sure that the default theme is in the themes folder before doing this. Your old theme may be causing errors.
Alright, I deleted all my themes except the default theme. WordPress currently is set to the Default theme, and I still don’t see my database listed.
WordPress appears to be finding a database (“Your WordPress database is already up-to-date!”) and otherwise you’d be getting no database or error establishing database connection errors. Make sure that you have the correct database listed in your wp-config.php.
I do have the correct database listed in my wp-config.php file, everything is correct, should I try switching around the username and password?
I do have the correct database listed in my wp-config.php file, everything is correct, should I try switching around the username and password?
No, if these were wrong, you’d get the error establishing database connection warning.
I didn’t get a “error establishing database connection warning” it’s just the current database did not migrate as I mentioned wordpress gave me a sign saying “Your wordpress database is alrady up to date”
So then what to do next?
How do you know that your database did not upgrade? What are the signs?
