The solution to mysql unique prefix myisam_recover instead of myisam recover options

It literally means you have to write all the parameters. This is not supported in later versions.

Many online information are directly using myisam_recover can achieve mysql database table repair, but in the new version of the need to add parameters can be.

The original:

myisam_recover

Now:

myisam_recover_options=force,backup

Automatically fixes myisam tables for MySQL

Common MySQL children's shoes all know that this myisam type table is very easy to damage, most people may be using myisamchk command to artificial repair, the following introduction of 1 automatic repair myisam method, is also my morning just learned, progress together, ha ha ~
In my.cnf configuration file of MySQL, myisam-recover is added in the boot item part to set data recovery function. The specific parameters are as follows:

I set the BACKUP and FORCE parameters as follows:
[mysqld]
myisam-recover=BACKUP,FORCE
This parameter details, please refer to the manual MySQL http: / / dev mysql. com/doc refman / 5.0 / en/server - options. html.