ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted

执行MySQL相关操作的时候,出现如下错误:

ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted

Google获知是因为升级或者数据版本迁移的问题,忽然想起前段时间确实把MySQL5.1版本的数据迁移到了现在的MySQL5.5上,罪过罪过,Linux终端下执行如下命令即可修复:

# /usr/local/mysql/bin/mysql_upgrade -uroot -pyoupassword

# /usr/local/mysql/bin/mysqlcheck --all-databases -uroot -pyoupassword  //执行以上命令成功后,可以再次检查表有没有错误
posted @ 2012-11-10 17:37  枯木-Linux  阅读(351)  评论(0编辑  收藏  举报