I lost posts while updating WordPress

Your description is a bit confusing but let me try my simple approach before getting into this deeper.

Open your wp-config.php file in the root directory of your FTP.

Then I would see what database is being called – if it’s the new one, switch it to the old one.

Basically what I’m saying is to look at this section:

// ** MySQL settings – You can get this info from your web host ** //

/** The name of the database for WordPress */
define(‘DB_NAME’, ‘YOUR DB NAME HERE’);

/** MySQL database username */
define(‘DB_USER’, ‘YOUR USER HERE’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘YOUR PASSWORD HERE’);

/** MySQL hostname */
define(‘DB_HOST’, ‘YOUR HOST HERE’);

and ensure everything is the way it should be to coincide with your old settings.

I have tried it when I got the message telling “Error establishing a database connection”.
Now, excepting the newly loaded WP, there is nothing in the old WP files. My mySql back up files and uploads are saved and already in the directory. But the database page shows only the newly created DBs. And that is what you can see in my site now.

So, I think I have to link the old DB backups to the new installation. Don’t know how, excepting vague ideas.

And the stored error logs are not EDITABLE (can’t even read/ cant open).

Ack – I’m sorry but I’m not sure what I’d do in this situation. Hopefully someone else can come in and share an idea because I’ve never experienced this before.

Future note – definitely get a backup plugin like BackupBuddy or something just in case this happens again. I’d also suggest setting up a DEV Site (test site) to do all updates on before going hot on your live site.

Best of luck.

@hockeyhero4, Thanks a lot for the advice. The problem is persisting, more or less, from what I understand from other similar posts in this forum, I think, I may have to change hosting. I had similar problems with some other blogs hosted elsewhere before. But I could solve them with the help of the customer support.

Thanks again.

Sorry, I did not report here that the issue was resolved. The problem was in the corrupt database files which I repaired. I set it alright and the site is back to normal.

I am having the same problem….. I completed the WordPress update. Now I have lost 2 days of post and I can’t log into wordpress not. PLEASE HELP

@mpromp2,
Wait. I am busy elsewhere. I will look into it after a few minutes.

This is so damn annoying, it has happened to me on 3 sites.

I have lost all 2011 and 2012 posts after upgrades. Went to Twenty Eleven theme, changed permalinks to default, tried use google library plugin, so not sure why my most recent posts are missing.

Example of my most recent post that is gone: https://www.exploreafrica.net/blog/2012/06/

Get internal server error!

Please help.
Cathryn

@janiceandcompany, @info@exploreafrica.net, @mpromp2
Please create your own topic as this one is resolved.