Fixed: Maria DB – Row size too large (> 8126) – Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED

When trying to import an SQL file with InnoDB, Maria DB users can see the following message as an error or warning:.

SQL Error (1118): Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

These messages indicate that the table’s definition allows rows that the table’s InnoDB row format can’t actually store.

To fix this error, in Maria DB (tested in version 10.6.5), follow the steps below:

Open the my.ini file of Maria DB.

1. Click the Wamp icon in the tray
2. Select MariaDB from the pull up menu.
3. Select my.ini from the pull menu.

Change the following keys to values as below

1. innodb-default-row-format=dynamic
2. innodb-strict-mode=off

Save the files and restart the service, the data should be imported without error now.