I'm trying to move the last few databases off an older mysql server, but one in particular has me stumped:
ERROR 1118 (42000) at line 595: 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.
The server being migrated to is running
5.6.29-76.2-log Percona Server, which appears to have a workaround for a transactional consistency bug with large BLOBs.
Since modifying innodb_log_file_size requires a service restart, is there a way to import a database with transactions disabled or something? SQL*Loader has a number of options for disabling transactions on an import, maybe there's a similar tool & setting for MySQL?