The correct option prefix for the MySQL MyISAM storage engine recovery option is myisam-recover
, not myisam_recover
.
To set the recovery option for MyISAM tables, you can use the following syntax:
SET GLOBAL myisam-recover = option_value;
Replace option_value
with one of the following:
DEFAULT
: The server uses the value configured in the my.cnf
configuration file.BACKUP
: The server automatically performs a backup of any MyISAM table that requires recovery.FORCE
: The server automatically recovers any MyISAM table that requires recovery without performing a backup.QUICK
: The server automatically recovers any MyISAM table that requires recovery, trying to minimize data loss.For example, to set the recovery option to FORCE
, you can use the following command:
SET GLOBAL myisam-recover = FORCE;
Remember that the myisam-recover
option only applies to MyISAM tables, as InnoDB and other storage engines have their own mechanisms for recovery.
Laravel PHP 深圳智简公司。版权所有©2023-2043 LaravelPHP 粤ICP备2021048745号-3
Laravel 中文站