mysql on the use of Myisam_recover automatic repair
- 2021-01-03 21:08:05
- OfStack
Myisam_revocer controls how Myisam finds and fixes errors.
Automatic repair of MySQL's myisam table
Commonly used MySQL children's shoes know that this TYPE of myisam table is very easy to damage, most people may be using myisamchk command to repair manually, the following introduces 1 automatic repair myisam method, I just learned this morning, common progress, ha ~
In the configuration file my.cnf of MySQL, add ES18en-ES19en to the startup section to set the data recovery function. The specific parameters are as follows:
|
DEFAULT |
与没有使用--myisam-recover选项相同。 |
|
BACKUP |
如果在恢复过程中，数据文件被更改了，将tbl_name.MYD文件备份为tbl_name-datetime.BAK。 |
|
FORCE |
即使.MYD文件将丢掉多个行也进行恢复。 |
|
QUICK |
如果没有删除块，不要检查表中的行。 |
How to use: add to my.ini
myisam_recover_options=force,backup