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,…read more