Laravel  
laravel
文档
数据库
架构
入门
php技术
    
Laravelphp
laravel / php / java / mysql

mysql unique option prefix myisam_recover instead of myisam-_MySQL

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

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

大家都在看

php进入mysql(php进入根目录)

php链接不到mysql(php连接mys

php连接小马(php连接mysql代码)

php与ldap怎么连接(php pdo连

php代码后台增删改查(php对mysql

[PHP从小白到大牛]-022 PHP操作

php搭建mysql连接池

PHP MySQL:连接MySQL数据库

PHP访问MySQL查询超时设置

PHP 原生连接 Mysql

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

Laravel 中文站