How to use Myisam_recover automatic repair in Mysql _mysql

Myisam_revocer controls the way Myisam find and fix errors.

Automatic repair of MySQL MyISAM table

Common MySQL children's shoes know that this myisam type of table is very easy to damage, most people may be using the MYISAMCHK command to manually repair, the following introduces a method of automatic repair MyISAM, but also I am just learning, common progress, hehe ~
In the MySQL configuration file my.cnf, the startup item part joins Myisam-recover to set the data recovery function, the specific parameters are as follows:

DEFAULT	Same as not using the--myisam-recover option.
BACKUP	If the data file is changed during the recovery process, it will be tbl_name. MyD file backup is tbl_name-datetime. Bak.
FORCE	Even. The MyD file will lose multiple rows and recover.
QUICK	If you do not delete the block, do not check the rows in the table.

How to use: Add in My.ini

Copy Code code as follows:

Myisam_recover_options=force,backup