Error code:1728 Cannot load from mysql.proc. The table is probably corrupted
来源:互联网 发布:万能五笔练习软件 编辑:程序博客网 时间:2024/04/30 19:16
Error code:1728 Cannot load from mysql.proc. The table is probably corrupted
http://bugs.mysql.com/bug.php?id=50183
原因是mysql.proc 在5.1 comment char(64) -> 5.5 comment text 导致
The difference seen in the mysql.proc table is
5.5
< `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
---
5.1
> `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
我们只需要将table proc column comment 改为text类型就可以了
ALTER TABLE `proc`
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
http://bugs.mysql.com/bug.php?id=50183
原因是mysql.proc 在5.1 comment char(64) -> 5.5 comment text 导致
The difference seen in the mysql.proc table is
5.5
< `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
---
5.1
> `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
我们只需要将table proc column comment 改为text类型就可以了
ALTER TABLE `proc`
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
0 0
- Error code:1728 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
- Cannot load from mysql.proc. The table is probably corrupted
- ERROR 1548 (HY000): 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的解决办法
- 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
- BUG: 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
- 1548-Cannot load from mysql.proc. The table is probably corrupted
- Cannot load from mysql.proc. The table is probably corrupted 问题解决
- Python学习-Numpy数据处理
- linux下安装maven
- leetcode--LRU Cache
- 解决下载下来的flexgrid.js下载下来直接使用数据不能显示的问题
- php json_encode() 数据
- Error code:1728 Cannot load from mysql.proc. The table is probably corrupted
- 彻底明白如何设置minSdkVersion和targetSdkVersion
- 排序算法——选择排序
- css media属性说明
- iOS:关于获取网络类型和运营商信息
- 【Linux】将终端的命令输出保存为txt文本文件
- 「译」不侧漏精通 Node.js
- position:relative;top属性移动div后的空白怎么去掉
- 阿里云服务器异地登录报警