This is a problem with a table or tables being corrupted. An example error message is:
Can't open file: 'cc_pages.MYD'. (errno: 145)
which is returned when trying to query the table.
To fix this, you can use the myisamchk utility.
Here's a sample session to fix this table:
[root]# myisamchk cc_pages.MYI Checking MyISAM file: cc_pages.MYI Data records: 1350 Deleted blocks: 1648 myisamchk: warning: Table is marked as crashed myisamchk: warning: 38 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain myisamchk: error: Record at pos: 170312 is not remove-marked myisamchk: error: record delete-link-chain corrupted - check index reference - check data record references index: 1 myisamchk: error: Found 1535 keys of 1350 - check record links myisamchk: error: Record-count is not ok; is 1349 Should be: 1350 myisamchk: warning: Found 1649 deleted blocks Should be: 1648 myisamchk: warning: Found 4208 parts Should be: 4209 parts MyISAM-table 'cc_pages.MYI' is corrupted Fix it using switch "-r" or "-o"
[root]# myisamchk -r cc_pages.MYI - recovering (with sort) MyISAM-table 'cc_pages.MYI' Data records: 1350 - Fixing index 1 Data records: 1349
