Bug #33315 Migration is not taking place for LONGBLOB
Submitted: 18 Dec 2007 5:25 Modified: 6 Feb 2009 12:15
Reporter: aijaz ahamed Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S5 (Performance)
Version:1.1.10 OS:Windows (WindowsXP)
Assigned to: CPU Architecture:Any
Tags: MySQL, MySql Migration toolKit, windows xp

[18 Dec 2007 5:25] aijaz ahamed
Description:
I am trying to migrate database from mysql4.
 I have Column of type LONGBLOB In a table which contains an Image .
the migration tool is created the table data in the field is null 

How to repeat:
create a table with a field of type LONGBLOB store some data in it. try to migrate the database using migration tool data field is of column type LONGBLOB will be null
[18 Dec 2007 9:18] Valeriy Kravchuk
Thank you for a problem report. Please, send a dump or just .frm, .MYD and .MYI files (if it is MyISAM) for the table that demonstrates this problem.
[19 Jan 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[22 Jan 2008 4:32] aijaz ahamed
.frm, .MYD and .MYI files for the table that demonstrates this problem.

Attachment: bug-data-33315.zip (application/x-zip-compressed, text), 24.79 KiB.

[22 Jan 2008 4:34] aijaz ahamed
.frm, .MYD and .MYI files for the table that demonstrates this problem were attached
[17 Oct 2008 14:23] Valeriy Kravchuk
Please, try to repeat with a newer version, from GUI Tools 5.0-r13, and inform about the results.
[18 Nov 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[6 Feb 2009 12:15] Susanne Ebrecht
MySQL migration tool only support MySQL server version 5.0 and higher.

Also the migration tool is not for migration from older MySQL versions to newer versions. Therefor we have upgrade scripts.

More information about upgrade you will find here:
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-5-0.html