Error: Row size too large (> 8126)
Posted: Wed Aug 10, 2022 11:04 am
In case you see this error during the import of the database:
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.
Those are steps to fix this:
1. In your SSH, as root, run:
This command will add "innodb_strict_mode = 0" at the end of MariaDB config file.
2. After that restart MariaDB server:
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.
Those are steps to fix this:
1. In your SSH, as root, run:
Code: Select all
echo "innodb_strict_mode = 0" >> /etc/mysql/mariadb.cnf2. After that restart MariaDB server:
Code: Select all
systemctl restart mysql