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)
No comments to display
No comments to display