Sanchan World Blog

Repair the corrupted table in MySQL

Sometimes, high load on the server, multiple INSERTs and UPDATEs, many SELECT query execution, or hardware failure, your database server may corrupt a table.

The corrupted table can be repaired back using the following statement:

REPAIR TABLE tablename;