Skip to main content

How to repair a crashed table

I had a crashed searchindex table in my MediaWiki, so I:

  • Connect to the server

#mysql -u root -p

  • Connect to the database

mysql> use wikidb;

  • check data

mysql> check table searchindex;
+--------------------+-------+----------+----------------------------+
| Table              | Op    | Msg_type | Msg_text                   |
+--------------------+-------+----------+----------------------------+
| wikidb.searchindex | check | warning  | Table is marked as crashed |
| wikidb.searchindex | check | status   | OK                         |
+--------------------+-------+----------+----------------------------+
2 rows in set (0.24 sec)

  • fix it

mysql> repair table searchindex;
+--------------------+--------+----------+----------+
| Table              | Op     | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| wikidb.searchindex | repair | status   | OK       |
+--------------------+--------+----------+----------+
1 row in set (0.21 sec)