一切福田，不離方寸，從心而覓，感無不通。

MariaDB 10.4.12 Stable Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.

MariaDB 10.4.12 Stable#

Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.#

以下两步解决问题

1. 修改my.ini文件在[mysqld]下面加入下面三行#

1
2
3
innodb_file_per_table
innodb_file_format = Barracuda
innodb_strict_mode = 0

 

2. 新建一个查询进行如下操作将nombre_tabla改成你的表名#

1
2
3
ALTER TABLE nombre_tabla
    ENGINE=InnoDB
    ROW_FORMAT=COMPRESSED;

 

 

from:https://www.cnblogs.com/fanlinglong/p/12425116.html

Copyright © 2024 Longsheng All rights reserved