Error: Row size too large (> 8126)

Post Reply
User avatar
Team Member
Posts: 130
Joined: Mon Jul 19, 2021 1:41 am
Has thanked: 16 times
Been thanked: 3 times

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:

Code: Select all

vi /etc/mysql/mariadb.cnf
At the end of this file add this:

Code: Select all

innodb_strict_mode = 0
2. After that restart MySQL server:

Code: Select all

systemctl restart mysql

Post Reply