Hi all,

All of a sudden, out of nowhere, I can no longer access the Couch admin panel. After a login attempt, I get an error message that says:

Code: Select all

Could not successfully run query: Table 'exagramm_bdsp_couch.couch_comments' doesn't exist.

I checked in the MySQL database and indeed, there is no couch_comment table. I just got off the phone with the hosting company, they checked logs but found nothing suspicious.

Does this kind of problem ring a bell with anyone?

I'm going to try and rebuild the table manually. There currently are 11 tables in the database, does that sound about right?

[KK]

Hi,

As far as I can recall, we've had only one such previous report (you'll find it somewhere on the forum) where all except one table disappeared into thin air.

Such happening can only be attributed to MySQL tables getting corrupt and your hosting provider needs to explain that.

I think restoring the database from a recent backup would be the only recourse.

Well, I did some digging and it turned out to be... drum roll... the hosting company!

They messed up real bad. This afternoon, they swore they hadn't touched my DBs. I later found out that all the tables in the DB had switched from InnoDB to MyISAM. In my experience, that doesn't happen unless you had to backup and restore everything and manually change the DB engine.

It felt good to shove it in their face. Everything works now, no thanks to them.

[KK]

Such incidences are always harrowing.
I am glad at least you did not incur any permanent data loss.
Serves to underline how imperative regular backups are for every site.