首页 > 数据库技术 > 详细

linux mysql5.7,[ERR] 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

时间:2020-12-23 12:38:47      阅读:32      评论:0      收藏:0      [点我收藏+]
使用kettle 迁移oracle数据库到linux mysql5.7时,字段较大创建表会报错
[ERR] 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
借鉴了别人的资料
https://www.cnblogs.com/wangjingu/p/10569479.html
http://www.bubuko.com/infodetail-3262232.html
发现都有点不对,第一个试了行不通,第二个的文件找到不到,后来根据自己的经验改了下,就可以了。

应该这样:
1、用root登录,修改 /etc/my.cnf;
2、在[mysqld]节点下,加入:
innodb_file_per_table=1
innodb_file_format=Barracuda
innodb_file_format_check = ON
innodb_log_file_size = 512M
innodb_strict_mode = 0
3、重启MySQL即可;  systemctl restart mysqld

  

 

linux mysql5.7,[ERR] 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

原文:https://www.cnblogs.com/asusdell/p/14177878.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!