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?
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.
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?
Yeah that is what I mean by upgrade “restore or to import a database”.
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:
- Make sure that everything is backed up.
- Install a fresh version of your former WordPress version (2.0 or 2.1) with a brand new database. Download it from the release archive.
- Restore your old database using the non-upgraded backup copy.
- Upgrade WordPress.
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.
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.
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.
I have a feeling wordpress overwrote my old database so can’t I just overwrite the database I have backed up ontop of it and it will work?
