Strange error: Can't open file: 'cache.MYI'.

jibbajabba - July 15, 2004 - 20:42

Getting the strange error below on my host. Does this mean anything to anyone?

Fatal error: Can't open file: 'cache.MYI'. (errno: 144) query: SELECT data, created, headers FROM cache WHERE cid = '/' in /home/.yar/asilomar/iaslash.org/includes/database.mysql.inc on line 97

» Login or register to post comments

corrupted table

marky - July 16, 2004 - 00:25

repair it.

phpMyAdmin can do this too if you have it available. ;)

/marky

Thanks, Marky

jibbajabba - July 16, 2004 - 14:11

Thanks, Marky. Repairing the table via phpMyAdmin didn't fix, however. Strange. Luckily it was just the cache table. I was able to drop and re-create the table, which worked out nicely.

TRUNCATE worked for me, but

pkreemer - November 8, 2005 - 03:41

TRUNCATE worked for me, but REPAIR didn't do anything. I did run repair after the truncate though.

Just happened to me.

noid - October 17, 2005 - 21:40

Just happened to me. Was able to repair the cache table using phpmyadmin -- I can access the site again. Does anyone have any idea what causes this error? Thanks. :)

i had the same problem

nsyll - May 26, 2006 - 13:55

but the repair form phpmyadmin fix it
thks

Had same problem. 'Repair'

Zach Harkey - May 1, 2008 - 14:44

Had same problem. 'Repair' seemed to work, then the problem returned so truncated the table and that seemed to do the trick.

-zach
--
harkey design

This just happened to me while transitioning our Drupal database on Media Temple from their standard database to their MySQL GridContainer. Logging into PhpMyAdmin showed the table as "in use." I wonder if the table was so big it didn't get "copied" over correctly? Anyway, selecting the table and using PhpMyAdmin to tell MySQL to repair it fixed the problem. I'm not sure if you can truncate a table that is "in use," but I bet that would have worked as well.

Josh

this thread

nrixham - October 6, 2008 - 16:48

is older than my son, and he's 4