MySQL importing from dump file error 1118 – Row size too large

Databases

Hi,

If you have faced a problem when importing your data to MySQL from a large file and it said:
ERROR 1118 (42000) at line xxx: Row size too large (> 8126)

This is a known bug for MySQL versions 5.6.20.0, 5.6.21.0 and I noticed that I didn’t have this problem at version 5.6.24.

In order to make it work also on MySQL 5.6.21.0 edit your “my.ini” configuration file and increase the innodb log size like this:
innodb_log_file_size = 256M
Hope it solves you the problem, like it helped me, one beer is always welcomed :-).

Best
Alex