Posted 1 year ago #
I have a problem, I have upgraded my wordpress from 2.0 or 2.1 to the latest version 2.6. Now the upgrade process went smooth but my database which is in perfect condition did not migrate to the upgrade
of wordpress.
How can I get my database into my current UPGRADED wordpress as it didn't do it as I thought it would?
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
Posted 1 year ago #
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.
Posted 1 year ago #
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?
Posted 1 year ago #
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.
Posted 1 year ago #
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.
Posted 1 year ago #
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.
Posted 1 year ago #
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.
Posted 1 year ago #
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?
Posted 1 year ago #
Well it would have shown my previous MySQL database logs that I had wrote the past year, within just the default theme.
You know when you write something over the course of a year you see a list of things you wrote and you can go back and read what you wrote four months ago. None of that is listing.
Oh, so your posts are not showing. Have you looked in the database (not the Wordpress admin) to see if they are there?
Posted 1 year ago #
Yeah, well I backed up the same database that I have on the server and to answer your question, yeah they are there.
Maybe your database needs repairing or has been somehow corrupted by the hack.
Posted 1 year ago #
No, from what has been checked on it, it is in good health and from viewing the back up of the database, I can officially say it's in good health. I suppose Wordpress upgrade can't migrate an old database into upgraded wordpress versions.
Which stinks cause anyone who is in this situation or was realized that all their blog posts from the past are toast and they have to start new.
I suppose Wordpress upgrade can't migrate an old database into upgraded wordpress versions.
You can even upgrade from really old versions of WordPress. When you refer to "migrate", you don't mean to restore or to import a database do you?
Posted 1 year ago #
Yeah that is what I mean by upgrade "restore or to import a database".
Posted 1 year ago #
How come I upgraded wordpress, which when fine. WordPress upgraded the database which went fine but my database with all my past blog posts is not showing up when I go to my blog page, it's just empty what is not working and is wordpress even capable of such thing. It seems iridiax you have suggested many things and nothing seems to work so I don't know what to think anymore.
Oh... Upgrading, restoring and importing databases are very different procedures. Upgrading will only convert an existing database to be compatible with the most recent version.
Here's what I'd recommend:
Posted 1 year ago #
So what you are saying is, I have to
a) Install WordPress 2.0 or 2.1 (what if I don't remember what version I was using between the two ?)
b) Create a new Database, then restore you my old database (which I currently do have backed up) which will replace the new database, correct?
c) Then upgrade wordpress and the database will migrate ?
Also what do I do with my current wordpress installation, just delete all of it?
Yes. Backup everything to your home computer and then delete it from your website. As far as I know, you can't restore an old, outdated database to a current WordPress database, so you have to do your restore with a compatible older WordPress version database.
Posted 1 year ago #
I don't understand "As far as I know, you can't restore an old, outdated database to a current WordPress database, so you have to do your restore with a compatible older WordPress version database"
You sure this will work?
You sure this will work?
No, I can make no guarantees. However, if everything is properly backed up you can always restore things. Do not attempt this without backing up everything first.
Posted 1 year ago #
As far as I know, you can't restore an old, outdated database to a current WordPress database, so you have to do your restore with a compatible older WordPress version database
That brings me back around to the beginning, if install an older version of wordpress, and start with a new database then try to upgrade the database after wordpress is install to the current version it won't work, as you mentioned an outdated database to a current wordpress database won't work.
This topic has been closed to new replies.
