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.

使用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

  

 
posted @ 2020-12-23 12:05  若冲  阅读(1129)  评论(0编辑  收藏  举报