MySQL Bugs: #13285: Data not written to script file

Bug #13285	Data not written to script file
Submitted:	16 Sep 2005 21:39	Modified:	18 Oct 2005 19:54
Reporter:	Doug Hunting	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.18 rc	OS:	Windows (Windows XP Pro SP2)
Assigned to:		CPU Architecture:	Any

Description:
When selected to write a script file for the data transfer instead of running online exchange of data, nothing is written to script file.

How to repeat:
Unselect 'TRANSFER DATA ONLINE' and select 'Create Script File for insert statements'

-Hit Next
-No data written to script file

Thank you for the bug report.

Using an Access 2003 db as source with data. Below the script:

-- ----------------------------------------------------------------------
-- SQL create script
-- ----------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

DROP DATABASE IF EXISTS `testscript`;

CREATE DATABASE `testscript`
  CHARACTER SET latin1 COLLATE latin1_swedish_ci;

CREATE TABLE `testscript`.`tbl1` (
  `col1` SMALLINT(5) NULL,
  `col2` VARCHAR(50) NULL
)
ENGINE = INNODB;

SET FOREIGN_KEY_CHECKS = 1;

The create script work fine... It is only for the inserting of data that the error occurs...

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