Laravel  
laravel
文档
数据库
架构
入门
php技术
    
Laravelphp
laravel / php / java / vue / mysql / linux / python / javascript / html / css / c++ / c#

mysql unique option prefix myisam_recover instead of myisam-_MySQL

作者:夜雨行空   发布日期:2024-08-18   浏览:606

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.

上一篇:VS2013连接MySQL5.6成功案例一枚_MySQL

下一篇:Linux/UNIX和Window平台上安装Mysql_MySQL

大家都在看

mysqlavg函数保留小数

mysql经纬度距离计算

存储过程mysql

mysql with语句

mysql时间加减

brew 启动mysql

unsigned在mysql中是什么意思

mysql 插入更新

mysql.user

python mysql update

Laravel PHP 深圳智简公司。版权所有©2023-2043 LaravelPHP 粤ICP备2021048745号-3

Laravel 中文站