# 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)`