Database error - site crashed!!! db_cache is marked as crashed and should be repair

I need help... This is the error I am getting

1194 Table 'zen_db_cache' is marked as crashed and should be repaired

Does anyone know what this means and how to fix it.

Thanks

If you are with a host that provides you with cPanel - there is a repair Db function that you could try. I would back it up first.

As this is just a cache and only contains temp data you can uisng phpmyadmin select this table only and in a pulldown at the bottom you can select "empty" and go. This will clear the temp data data out if that is the issue

Tested both but fails. Db repair and phpmyadmin where the zen_db_cache is emptied but seems like nothing changes.

What is your most recent DB Backup date prior to this error?

For a busy shop, you should take one daily

There are several backups. For example one dates to April, 2006. While this time zen_db_cache is crashed and is void of content, the earlier backups show certain content like this:

-- Table structure for table zen_db_cache

DROP TABLE IF EXISTS zen_db_cache;
CREATE TABLE zen_db_cache (
cache_entry_name varchar(64) NOT NULL default '',
cache_data blob,
cache_entry_created int(15) default NULL,
PRIMARY KEY (cache_entry_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table zen_db_cache

/*!40000 ALTER TABLE zen_db_cache DISABLE KEYS */;
LOCK TABLES zen_db_cache WRITE;
INSERT INTO zen_db_cache VALUES ('.................................. so on

so on
so on, and after many lines ending like this:

UNLOCK TABLES;
/*!40000 ALTER TABLE zen_db_cache ENABLE KEYS */;

SHOULD THESE BE COPIED TO THE CRASHED DATABASE?

You do not need to include the "Dumping data .... " section for the db_cache table.

Thank you very much DrByte,

How the database is copied?

1. Thru phpmyadmin?
2. Or the online shop backend should be be used to upload this part:
   DROP TABLE IF EXISTS zen_db_cache;
   CREATE TABLE zen_db_cache (
   cache_entry_name varchar(64) NOT NULL default '',
   cache_data blob,
   cache_entry_created int(15) default NULL,
   PRIMARY KEY (cache_entry_name)
   ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

BTW the backend login is crashed too when the above mistake happens.
Googling on copying database brought some results written in quite technical jargon.

The best and fastest thing to do when you get that problem is to go into phpMyAdmin and click on the SQL tab and enter the following statement, and click Go:```
repair table zen_db_cache;

Doing that shows this:

import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: format (FAQ 2.8)

Checking again zen_db_cache shows:
Error

SQL query: Edit

SHOW INDEX FROM zen_db_cache ;

MySQL said: Documentation
#145 - Table './mydomain_zc1/zen_db_cache' is marked as crashed and should be repaired

Then your phpMyAdmin has some problems with it.
You could try doing the repair via your ZC Admin sql patch tool: ```
repair table db_cache;

If that doesn't work, or you can't access it, you'll have to drop the table and recreate it, using what you posted in your 2nd point in your previous post.

What causes the zen_db_cache file to get messed up? I just had the same problem, and the zen_db_cache had "in use" across the table. At first I tried restarting mysql service and then I tried restarting Apache thinking that something was tiing up my server and by restarting would break it connection, didnt work. So it must have been internal. So then I went to my database and tried backing up but it couldnt do it. Just got the header info.

After that I just went to the zen_db_cache and emptied it. Fixed it right away. Just don't know what caused it to go weird.

Can you explain?

Running repair table db_cache; at SQL command worked for me~!!!

Thanks!