How to specify a maximum number of bulk insert rows at a time

[Jeff Heon]

Greetings,

I'm trying limit to bulk insert batch size to a specific number of rows. I have MySQL Migration Toolkit 1.1.17, but I don't see the option in the advance settings of the Data Mapping Options Screen. There is one for limiting the total number of rows to migrate, but I only want to limit the batch size.

Right now, I'm getting batches of about 500 rows for per insert statement but unfortunately, I have a table with lots of longtext columns and I'm busting some limit. The table itself is created without any problems.

If I modify the data insert script after the fact to insert one row at a time, it works, but I've got 3000 rows to adjust 8p

I put the max_allowed_packet to 1000M, but I still get the infamous "Got error 139 from storage engine."

Thank you