hey thanks I did exactly what you just said... its work like a charm...
that check all my .myi files
then this came back
Checking MyISAM file: /var/lib/mysql/nagiosmysql/servicestatus.MYI
Data records: 37 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 2 clients are using or haven't closed the table properly
- check file-size
myisamchk: error: Size of datafile is: 5748 Should be: 5912
- check record delete-chain
- check key delete-chain
- check index reference
- check record links
myisamchk: error: Record-count is not ok; is 36 Should be: 37
myisamchk: warning: Found 36 parts Should be: 37 parts
MyISAM-table '/var/lib/mysql/nagiosmysql/servicestatus.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk --recover /var/lib/mysql/nagiosmysql/servicestatus.MYI
- recovering (with keycache) MyISAM-table '/var/lib/mysql/nagiosmysql/servicestatus.MYI'
Data records: 37
Data records: 36
Now it working
btw it wasnt because i remove some log file
I think the vm was full so must of trying to right some in a table
and then linux decided that he doesnt have access the the HD anymore?
I dont know, but its working now...
SO THANKS AGAIN!!!!