Thread

I’m running into a HUGE problem…

Client’s site was perfectly fine for years. Then all content is missing a couple days ago. Turns out the hosting company does NOT HAVE ANY backup of the MySQL DB and since I’m not hosting the site, I don’t either.

The weirdest part is that the forums seem to be mostly OK, everything else though (News, products, etc.) everything is gone. Even worst: I can’t login with my admin account… It says the user doesn’t exists.

I do realize that this might not be a EE issue, the DB corruption might be due to some external factor. But if you have any tip on how to create an admin account from phpmyadmin or any pointers on how I should trouble shoot or indications on how to maybe recover some data… I would be eternally grateful… I can email you guys the MySQL dump if that helps.

ANY idea welcome at this point.

Thanks…

So I got a MySQL dump of the borked site and found out there was about 75,000 users in the forum. All spam. Could it be a reason why the DB got corrupted?

I recreated my admin user directly from phpmyadmin and after editing out the spammy forum users and reimporting the DB, it looks like everything in exp_weblog_data is still there, but there are only 5 random entries in exp_weblog_titles which is why it’s not showing up. I Can’t think of a way to fix that.

Hi, minimal design.

Without a good backup, you’re going to run into issues. You’d need to redo the exp_weblog_titles table by hand. How many entries are we talking about?

Thanks.  I figure how to recreate my admin account, so can manage the disaster recovery plan… 😉

If I recreate exp_weblog_titles and enter those manually:

entry_id
weblog_id
title
url_title

I can set the others to a default value, it doesn’t really “matter” in order to show up in CP, correct?

You should be OK, but it doesn’t hurt to do just one and make sure it works. 😊

Absolutely… That’s the plan! Thanks.

OK… Good news. After having the client go crazy at the hosting company, they somehow found a backup that wasn’t supposed to exist and most of the content is back online, BUT EE is throwing some MySQL errors on the front end:

MySQL ERROR:

Error Number: 145

Description: Table './billg_ee090920/exp_referrers' is marked as crashed and should be repaired

Query: SELECT COUNT(*) AS count FROM exp_referrers WHERE site_id = '1' AND (ref_from = 'http://wavearts.com/products/' OR ref_ip = '74.73.244.66') AND ref_date > '1319584764'

What’s the best approach to trouble shoot + fix?

Thanks!

Great news 😊

Ok, so for an error like this you should be able to just repair that particular table by using phpMyAdmin. Are you familiar with that?