Error: Row size too large (> 8126)

[isscbta]

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

echo "innodb_strict_mode = 0" >> /etc/mysql/mariadb.cnf

This command will add "innodb_strict_mode = 0" at the end of MariaDB config file.

2. After that restart MariaDB server:

Code: Select all

systemctl restart mysql