MySQL unique option prefix myisam_recover instead of myisam-recover-options resolution _MYSQL

According to the literal meaning is to write the parameters of the whole. This is not supported in a later version.

Many of the information on the Internet is directly using Myisam_recover can be used to achieve the MySQL database table repair, but in the new version of the need to add parameters.

Originally:

Copy Code code as follows:

Myisam_recover

Right now:

Copy Code code as follows:

Myisam_recover_options=force,backup

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.

I set up the backup and force parameters as follows:
[Mysqld]
Myisam-recover=backup,force
For more information on this parameter, please refer to the MySQL manual http://dev.mysql.com/doc/refman/5.0/en/server-options.html.