今天数据库迁移测试,发现存储过程导入不了,提示如下错误:
Cannot load from mysql.proc. The table is probably corrupted
原因是mysql5.5版本后proc表中comment字段类型由char改成了text
解决方法:
ALTER TABLE `proc`
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `sql_mode`;
再重新用source命令导入就ok了