check and repair table

by RameshKumar 2010-01-27 19:05:32

Check the Specific table

mysql> CHECK TABLE <Table_Name>


Example:

mysql> CHECK TABLE hiox.music


In the above command the hiox is database name and music is the table name


To repair a mysql table use the below command to repair the mysql table

mysql> REPAIR TABLE <Table_Name>

Example:
mysql> REPAIR TABLE hiox.music

Repair music table in hiox DB.

Tagged in:

986
like
0
dislike
0
mail
flag

You must LOGIN to add comments