By Anonymous (not verified) on

Okay so my site recently crashed saying the Cache table crashed and should be repaired. Is there anything specific that may have caused this? And how should I go about fixing it?

Also got a bunch of errors like this:

user warning: Table './colliny2k_neo/cache' is marked as crashed and should be repaired query: DELETE FROM cache WHERE cid = 'variables' in /var/www/includes/database.mysql.inc on line 120.

[kbahey -- moved to correct forum. this is not scalability]

⋅ Categories: Drupal 4.7.x

Comments

kbahey’s picture

kbahey commented

If the hosting machine crashes (i.e. does not get shutdown cleanly), this can happen.

You need to run the REPAIR command from mysql or phpMyAdmin.

Google for the exact syntax at mysql.com
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

caprenter’s picture

caprenter commented

A friend of mine found this post really useful recently and wanted me to add this link as a guide to getting the repair done if you use phpMyadmin to communicate with your database:

http://php.about.com/od/mysqladministration/qt/repair_mysql.htm

Thanks for your help!

politicalparty’s picture

politicalparty commented

thanks so much for posting that link as a reference. i'm learning this all as i go along, i thought i was going to be up all night pulling out my hair trying to fix this.

alexpz’s picture

alexpz commented

I would like to thank you for the link and info. It did solve my problem also. Thanks again

Regards,
Alex

fawwadshafi’s picture

fawwadshafi commented

Thanks .
I got it.
Its working

dela.deyoungster’s picture

dela.deyoungster commented

Thanks so so much for the link. It really save me.

ryansnow’s picture

ryansnow commented

I just had this problem as well. Glad that it was so easy to fix. Is there settings or something to do with drupal to avoid this problem in the future? has it anything to do with poorman's cron?