Table is marked as crashed and should be repaired I have MySQL and Nagios installed Linux PC (Centos5.5)
I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table)
The data fetching working properly (confirmed with 'COUNT' cmd)
The problem when i run the following command its through error as below,

mysql&gt; select * from nagios_servicechecks;
ERROR 1194 (HY000): Table 'nagios_servicechecks' is marked as crashed and should be repaired

Except this command, all other commands working fine.
Please try the below query,

REPAIR TABLE nagios_servicechecks;


Try the above query in terminal or check the below link to repair table or databases via phpmyadmin

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