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


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, and I noticed that I didn’t have this problem at version 5.6.24.

In order to make it work also on MySQL 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 :-).



Get every new post delivered to your Inbox

Join other followers