mysql 表崩溃如何修复_MySQL表崩溃修复

MySQL日志报错

2019-10-19 13:41:51 19916 [ERROR] /usr/local/mysql/bin/mysqld: Table './initread_hss/user_info' is marked as crashed and should be repaired

2019-10-19 13:41:51 19916 [ERROR] /usr/local/mysql/bin/mysqld: Table './initread_hss/user_program' is marked as crashed and should be repaired

2019-10-19 13:42:08 19916 [ERROR] /usr/local/mysql/bin/mysqld: Table './initread_hss/user_info' is marked as crashed and should be repaired

2019-10-19 13:42:08 19916 [ERROR] /usr/local/mysql/bin/mysqld: Table './initread_hss/user_info' is marked as crashed and should be repaired

解决办法

1.如果您的MySQL进程正在运行，请停止它

转到您的数据文件夹。：

cd/var/lib/mysql/$DATABASE_NAME

尝试运行：

myisamchk-r$TABLE_NAME

如果这不起作用，您可以尝试：

myisamchk-r-v-f$TABLE_NAME

您可以再次启动MySQL服务器。：

sudo service mysqlstart

文章来源: www.oschina.net，作者：雁南飞丶，版权归原作者所有，如需转载，请联系作者。

原文链接：https://my.oschina.net/kcw/blog/3119554