Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

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

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

But the issue still persists.

Thanks in Advance.

like image 317
Srikanth A Avatar asked Jun 30 '15 13:06

Srikanth A


1 Answers

Try these:

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

Inside MySQL terminal

repair table mysql.proc;

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

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

like image 193
HashSu Avatar answered Oct 10 '22 09:10

HashSu