表'./mysql/proc'被标记为崩溃，应该修复 [英] Table './mysql/proc' is marked as crashed and should be repaired

问题描述

当我对mysql DB执行任何过程创建或更新操作时，出现以下错误

When i perform any procedure creation or update operation to mysql DB, i am getting the below error

表'./mysql/proc'被标记为已崩溃，应予以修复

Table './mysql/proc' is marked as crashed and should be repaired

尝试使用以下命令运行mysql isam restore- myisamchk -q -r/var/lib/mysql/mysql/proc

Tried to run mysql isam recover using below command - myisamchk -q -r /var/lib/mysql/mysql/proc

但是问题仍然存在.

预先感谢.

推荐答案

尝试以下方法:

mysqlcheck --auto-repair -A -u username -ppassword

在MySQL终端内部

repair table mysql.proc;

参考: https://dev.mysql.com/doc/refman/5.1/en/repair-table.html 修改my.cnf

Reference: https://dev.mysql.com/doc/refman/5.1/en/repair-table.html Modify the my.cnf

[mysqld]
character-sets-dir=/usr/share/mysql/charsets

参考: http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

这篇关于表'./mysql/proc'被标记为崩溃，应该修复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！