mysql之数据库迁移sql执行报错问题,有时候需要执行导出的sql文件,但是可能会报下面的错误:
[ERR] 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help.
解决办法:
//在mysql的配置文件下添加如下配置,再重启
innodb_file_per_table=1
innodb_file_format=Barracuda
innodb_file_format_check = ON
innodb_log_file_size = 512M
innodb_strict_mode = 0
