MySQL Import reports Row size too large... Changing some columns to TEXT or BLOB may help. Print

When importing a MySQL (or MariaDB) database or databases, the import fails with a response similar to:

Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.

This is due to rows within the InnoDB tables being outsized which trips a warning message.   However, newer versions of MariaDB / MySQL may have "InnoDB Strict Mode" enabled by default.   When it is enabled, certain InnoDB warnings become errors instead.   This causes an import to fail.    The solution is to run the following SQL statement via MySQL / MariaDB CLI or within phpMyAdmin:

SET GLOBAL innodb_strict_mode=ON;

More information: https://mariadb.com/kb/en/innodb-strict-mode/