Mysql, mysqlmyisam_recover
Myisam_revocer controls how Myisam locates and fixes errors.
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. |
Usage: In my. ini, add
Copy codeThe Code is as follows:
Myisam_recover_options = force, backup