ERROR 1118 (42000) at line : 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.

While migrating to the new server, I had the problem

ERROR 1118 (42000) at line : 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.

The work-around solution, according to mariadb.com, is to open the .sql file with nano and add the following at the top

SET GLOBAL innodb_default_row_format='dynamic';
SET SESSION innodb_strict_mode=OFF;

The import of the database went off smoothly. Hopefully, there will not be other problems.

There are other solutions suggested at stackexchange which did not work for me.

Leave a Reply

Your email address will not be published. Required fields are marked *