Increase the redo log size using innodb_log_file_size
Got this error while trying to import a large .sql file in MySQL Workbench: ERROR 1118 (42000) at line 171970: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size. Solution to the above error in XAMPP is as follows: In xampp\mysql\bin\my.ini file, set innodb_log_file_size = 128M (the default value was around 20M) Save the file and restart MySQL server.