check and repair table
by RameshKumar[ Edit ] 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.