关于 1118, 'Row size too large (> 8126) 的报错

in with 0 comment

将Mongodb中的数据,迁移到mysql会遇到下面的报错

sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (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.')

需要修改 mysql的配置参数:

innodb_file_per_table=1
innodb_file_format=Barracuda

修改完上面的参数还是不好使:

innodb_strict_mode = 0

还要加上这个参数

Responses