Mysql unique option prefix myisam_recover instead of myisam-recover-options solution, myisamrecover

Mysql unique option prefix myisam_recover instead of myisam-recover-options solution, myisamrecover

The literal meaning is to write all the parameters. This statement is not supported in later versions.

Many materials provided on the Internet can be repaired using myisam_recover directly, but parameters must be added in the new version.

Originally:

Copy codeThe Code is as follows:
Myisam_recover

Now:

Copy codeThe Code is as follows:
Myisam_recover_options = force, backup

Automatically repair MySQL myisam table

MySQL children's shoes often know that myisam tables are very vulnerable to damage. Most people may use myisamchk commands for manual repair. The following describes a method to automatically repair myisam, I just learned this morning and made progress together ~
In the MySQL configuration file my. cnf, add myisam-recover to the startup Item to set the data recovery function. The specific parameters are as follows:

DEFAULT	It is the same as the -- myisam-recover option.
BACKUP	If the data file is changed during the recovery processTbl_name. MYD file backup isTbl_name-datetime. BAK.
FORCE	The. MYD file will be restored even if multiple rows are lost.
QUICK	If the block is not deleted, do not check the rows in the table.

I have set the BACKUP and FORCE parameters as follows:
[Mysqld]
Myisam-recover = BACKUP, FORCE
For more information about this parameter, see MySQL manual http://dev.mysql.com/doc/refman/5.0/en/server-options.html.