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:
At the end of this file add this:
2. After that restart MySQL 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
vi /etc/mysql/mariadb.cnf
Code: Select all
innodb_strict_mode = 0
Code: Select all
systemctl restart mysql