Last Updated: February 25, 2016
·
365
· laupifrpar

MySQL: Row is too large

If you have the following error on Mac OS X,

Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROWFORMAT=DYNAMIC or ROWFORMAT=COMPRESSED

You must configure the mysql server.

Edit your file ~/.my.cnf (see Where is the my.cnf file ?)

[mysqld]
max_allowed_packet = 1G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M

Then restart mysql server. If you installed mysql with brew, the command to restart is mysql.server restart

Source: StackExchange - Row size too large 8126