• Mysql

Row size too large (> 8126). Changing some columns to TEXT or BLOB… | Mysql / MariaDB

By PrasadNaik

March 31, 2021

I was getting error “Row size too large (> 8126). Changing some columns to TEXT or BLOB… | Mysql / MariaDB” while dumping database

The fix to this issue is to add below parameter in /etc/my.cnf

innodb_strict_mode = 0


and restart mysql