Mysql报Cannot load from mysql.proc. The table is probably corrupted
来源:互联网 发布:孙楠退赛真相 知乎 编辑:程序博客网 时间:2024/04/26 21:50
1548-Cannot load from mysql.proc. The table is probably corrupted
http://bugs.mysql.com/bug.php?id=50183
原因是mysql.proc升级时有个字段没有升级成功。
在5.1中mysql.proc表的comment字段是varchar(64):
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
但在5.5中应该是text:
comment
text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, So,执行下面的语句,把这个字段修改为text,就彻底OK了:
ALTER TABLE `proc`MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `sql_mode`;
阅读全文
0 0
- Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- Mysql报错:Cannot load from mysql.proc. The table is probably corrupted
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- 1548 cannot load mysql.proc.the table is probably corrupted
- 解决MySQL中【Cannot load from mysql.proc. The table is probably corrupted。】的问题
- MySQL 1548 Cannot load from mysql.proc. The table is probably corrupted的解决办法
- BUG: Cannot load from mysql.proc. The table is probably corrupted
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted
- BUG: Cannot load from mysql.proc. The table is probably corrupted
- 1548-Cannot load from mysql.proc. The table is probably corrupted
- create stored procs Cannot load from mysql.proc. The table is probably corrupted
- Error code:1728 Cannot load from mysql.proc. The table is probably corrupted
- 1548-Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted 问题解决
- 【脚本语言系列】关于Python基本元素,你需要知道的事
- Android 中的cookie
- hdu 1002 A + B Problem II(大数相加)
- TinkPHP5 RESTful API开发版本控制
- 获取checkbox返回undefined,实现全选/取消
- Mysql报Cannot load from mysql.proc. The table is probably corrupted
- Struts2_配置eclipse
- Android之RemoteViews
- git常用操作
- 在android studio中使用kotlin
- RandomAccessFile使用
- 倾斜影像的分辨率与矢量数据比例尺之间的关系
- 零基础搭建Shadowsocks(三)
- cocos2dx中Sprite执行延时动作时打断可能产生非预期后果