I'm maintaining a webserver with MySQL v3.23.49
When I try to view a table called sumhits I get the following error
Can't open file: 'sumhits.MYD'. (errno: 145)
So, a .myd file must be some definitions file. I don't have a backup (the problem predates my involvement) or even an idea of how this file should look.
If I browse around the box I find
-rw-rw---- 1 mysql mysql 98672640 May 16 04:30 sumhits.MYD
-rw-rw---- 1 mysql mysql 25489408 May 16 05:00 sumhits.MYI
-rw-rw---- 1 mysql mysql 8740 Aug 15 2001 sumhits.frm
so a file with that name is there, and has content, but hasn't been updated for ages - should have been! I'm guessing it's been corrupted.
Is there anyway I can recover this table?
Sarah
