MySQL table repair
If your MySQL table is corrupted or damaged, then just follow this command to MySQL Table Repair following with the extension.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$
myisamchk -r *.MYY to repair msql
$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Understanding the command:
myisamchk – this is the command can be used to repair MySQL database tables.
-r – recursive function to perform the repair task
*. – * represents all the names before the (.) has to be taken for the database repair.
.MYY – .MYY represents the mysql database table extension. we can change the extention
OR
MySQL tables can also repaired in the following way:
mysql> use dtabase(ie in which database the table is includeed)
mysql> REPAIR TABLE `tbl_name`
$$$$$$$$$$$$$$$$$$$$$$$$$$$$