ulrichbeinert

Thanks, you too!

Hi Balint,

first off: don’t be sorry for writing too much! I am so thankful you are taking all this time for me!

My site is more or less back up and running, thanks to you! What I did was this: I exported the database, leaving out the corrupt tables. I then imported them into a new database and put the new database in the wp_config.php file. Still, I got the same error message, since the database was now missing two tables. No way to create these easily, so I cleared the database again and went to https://www.domain.com/wp-admin/, which prompted WordPress to start a fresh install of the database. Now I had a blank database with the correctly formatted tables and imported my backup into that (everything intact and just the two tables empty). Now I have to work on the options and settings to get the site looking as it was before, but I’m nearly there.

The database was small, by the way, 2 MB. It’s a fairly new site and I haven’t done much work on it yet. I don’t believe I had a single comment, so losing those was no problem at all. The settings won’t be much work, if I can remember approximately what I did last time.

So, for now, it’s working again. Thanks a million for all your help!

Hi Balint,

I was working for a few days, so here’s my late answer. I don’t have access to the WordPress admin environment due to this problem. So I can only backup the database from phpMyAdmin. That’s why I was asking if backup just means exporting the database. Unfortunately, the hosting company can only do a recovery using a backup for 100 €, too much for such a “simple” problem, if it really means I can recover everything else aside from these tables.

Once I’ve done the backup, what’s the best way to reinstall? Do I reinstall all of wordpress? Or just the database? It would be good to keep as much of the data that’s okay, so I’m thinking I don’t need to delete the pages of my website, do I?

This is all a bit confusing. I come from programming straight-up HTML, all by myself, no WYSIWYG, and I always knew the exact structure of my site. With wordpress, there’s a lot of invisible stuff going on for me.

Regards,
Ulrich

Hi Balint,

thanks for your fast reply. The PHP version change was something I tried *after* the problems occurred. The last updates I did, after those everything was working. I don’t know what happened inbetween then and now.

An update of the database is just a simple export? Or is there more I have to do?

Since it’s just the wp_comments and wp_options that are corrupted, can I import my backup database with the exception of these two tables, to recover all data except these two? I don’t have any comments and the options won’t be too much trouble to insert again, I guess.

Thanks,
Ulrich