Bug #14215 The SQL create statements could not be created (error: 0).
Submitted: 21 Oct 2005 16:51 Modified: 24 Nov 2005 12:39
Reporter: Matthew Bilek Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.0.20 OS:Windows (Microsoft Windows Server 2003)
Assigned to: CPU Architecture:Any

[21 Oct 2005 16:51] Matthew Bilek 
Description:
When Migrating data from MySQL 4.1.14 to 5.0.13 I receive the following error in the message log of the bulk transfer screen:

SELECT `collection_item_file_id`, `collection_id`, `item_file_id`, `active`, `metadata`, `security_user_id`, `timestamp` FROM `spy_prod`.`collection_item_file`
The SQL create statements could not be created (error: 0).
MigrationMysql.dataBulkTransfer :Java heap space
Details:

I have downloaded the appropriate Java Runtime Environment 'J2SE Runtime Environment 5.0 Update 5' 1.5.0.50.

Migrating from MySQL 4.1.14 to MySQL 5.0.13.

How to repeat:
Please call or e-mail for details.
mbilek@webroot.com
1-303-442-3813 x192
[25 Oct 2005 16:51] Matthew Bilek 
At the Schema Creation stage I have an error log for each table with the following text:
You have an error in your syntax; check the manual that corresponds to you MySQL server version for the right syntax to use near 'NOT NULL DEFAULT 'false', `active` ENUM NOT NULL DEFAULT 'false', `metadat' at line 5.

It appears to be having problems defining the schema, plus it is not interpreting the ENUM correctly.  The original creation of the row looks like this:
`active` enum('false','true') NOT NULL default 'false',
[26 Oct 2005 21:23] Jorge del Conde 
Thanks for your bug report.  I was able to reproduce this bug using the provided schema in 1.0.20
[24 Nov 2005 12:39] Michael G. Zinner 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html