MySQL Bugs: #60147: MySQL Migration Toolkit migration script fails to pick up advanced BLOB options

Bug #60147	MySQL Migration Toolkit migration script fails to pick up advanced BLOB options
Submitted:	16 Feb 2011 17:54	Modified:	16 Feb 2011 18:14
Reporter:	Martin Clarke	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.17	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	BLOB

Description:
If a migration script is generated the 

Data Mapping Options, 
Advanced Options 
...
[/] Override BLOB limit of 4MB
or
[/] Use BLOB streaming

are ignored, which causes the script to generate many of these:

ERROR: The following error occured while transfering binary data from <TABLE>, column DATA BLOB is larger than 4MB.

Following

http://forums.mysql.com/read.php?104,58793,59257#msg-59257

You can also add the parameter "OverrideBlobLimit" to the dataBulkTransferParams. In function Mig:bulkDataTransfer() at the very end of the MigrationScript.lua file, add the parameter and set it to "yes". 

doesn't resolve the problem.

Higher up in that link it says:

To increase the 4MB limit, open java\com\mysql\grt\modules\MigrationGeneric.java and search for the 
getEscapedHexString() function. Change the *4 to *8 or *16 in the following code and re-compile the file. 

if ((currentSize > 1048576 * 4) && (!doOverrideBlobLimit)) { 
throw new RuntimeException("BLOB is larger than 4MB."); 
} 

I'd love to but there are no instructions on recompiling the java.

How to repeat:
Invoke a MySQL Migration Toolkit, Advanced Options, [/] Override BLOB limit of 4MB or [/] Use BLOB streaming generated migration script.

Well, it is unsupported for a long time, and Oracle has nothing to do with this. Check http://www.mysql.com/support/eol-notice.html:

"December 18, 2009
EOL of MySQL Query Browser, MySQL Administrator, MySQL Migration Toolkit

With the beta releases of MySQL Workbench 5.2 well under way, we are announcing the EOL of the MySQL GUI Tools Bundle.

...

Starting Dec 18, 2009, MySQL will no longer accept bug reports submitted against the MySQL GUI Tools Bundle, and existing bug reports against these tools will no longer be worked on."

Old bad news. Sorry. One day, maybe, Migration Toolkit will re-appear in Workbench. Who knows...