MySQL Forums
Forum List  »  General

How to specify a maximum number of bulk insert rows at a time
Posted by: Jeff Heon
Date: July 14, 2010 10:59PM


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

Options: ReplyQuote

Written By
How to specify a maximum number of bulk insert rows at a time
July 14, 2010 10:59PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.