MySQL said: #1194 - Table 'tablename' is marked as crashed and should be repaired

Question

If tables are crashing it means something is wrong with my system.

MySQL said: 

#1194 - Table 'tablename' is marked as crashed and should be repaired 

My website is currently down because of this.

I know how to repair table from phpmyadmin but is it safe way to repair?

What is the important factor for this issue?

Question. Generally, Why table get crashed?

Answers. These may be the reasons -

1. Server's disk space was full. (Please check disk space in live server)

2. Incorrect shutdown MySQL server/Improperly closing the tables while using the databases.

3. More server load.

Answer 1

First of all - there are many reasons for a crashed table.

• harddisk failure
• sudden server reboot
• server crash
• firmware problems (raid controller or bios)
• defects in the cabling
• etc.

A repair with phpmyadmin does basically the same as the mysqlrepair commandline. I would suggest to repair everything on command line:

mysqlrepair -A --auto-repair
mysqlrepair -A -o

Or start a test:

mysqlrepair -A -c

Answer 2

If you don't have commandline tools needed, and reason for crash is most likely is MYSQL itself, run this from MYSQL to repair a table:

REPAIR TABLE db_name.table_name;