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

[scully2569]

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

[kobra]

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

[zenartman]

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

[kobra]

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

For a busy shop, you should take one daily

[zenartman]

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?

[DrByte]

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

[zenartman]

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.

[DrByte]

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;

[zenartman]

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

[DrByte]

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.