linux下mysql无法启动 './mysql/user' is marked as crashed and should be repaired
    文章作者:恒爱云[恒爱网络] 阅读次数:1276 发布时间:2025-2-6

    客户的linux系统下安装的宝塔,突然MYSQL数据库无法启动 ,报错  './mysql/user' is marked as crashed and should be repaired

    强制启动会提示成功,然后自定停止。因此需要修复损坏的数据表  /mysql/user

    远程登录系统后,根据时间表实际位置,执行修复命令 myisamchk -r /www/server/data/user.MYI

    报错 : Using unique option prefix write_buffer instead of write_buffer_size is   deprecated and will be removed in a future release. Please use the full name instead.

    修改mysql.cnf配置文件里的  write_buffer 为 write_buffer_size

    再次执行又报错 : Warning: Using unique option prefix read_buffer instead of read_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.

    修改mysql.cnf配置文件里的  read_buffer 为 read_buffer_size

    然后再次执行修复命令又提示 :myisamchk: error: 140 when opening MyISAM-table '/www/server/data/mysql/user.MYI

    这是MYsql5.6 的一个BUG ,去掉后缀.MYI 即可,即执行:  myisamchk -r /www/server/data/user

    提示修复完成,再次后台启动MYSQL 成功!