GNU Info

(mysql.info)REPAIR TABLE

---

Next: Table maintenance Prev: CHECK TABLE Up: Disaster Prevention

---

Enter node , (file) or (file)node

`REPAIR TABLE' Syntax
---------------------

     REPAIR TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED]

`REPAIR TABLE' only works on `MyISAM' tables and is the same as running
`myisamchk -r table_name' on the table.

Normally you should never have to run this command, but if disaster
strikes you are very likely to get back all your data from a MyISAM
table with `REPAIR TABLE'. If your tables get corrupted a lot you should
try to find the reason for this! Note: Crashing. Note: MyISAM table
problems.

`REPAIR TABLE' repairs a possible corrupted table. The command returns a
table with the following columns:

*Column*                  *Value*
Table                     Table name
Op                        Always "repair"
Msg_type                  One of `status', `error', `info' or `warning'.
Msg_text                  The message.

Note that you can get many rows of information for each repaired table.
The last one row will be of `Msg_type status' and should normally be
`OK'.  If you don't get `OK', you should try repairing the table with
`myisamchk -o', as `REPAIR TABLE' does not yet implement all the
options of `myisamchk'. In the near future, we will make it more
flexible.

If `QUICK' is given then MySQL will try to do a `REPAIR' of only the
index tree.

If you use `EXTENDED' then MySQL will create the index row by row
instead of creating one index at a time with sorting;  This may be
better than sorting on fixed-length keys if you have long `char()' keys
that compress very good.