Bug #36182 Bulk Transfer via lua script and grtsh.exe results in 'DROP DATABASE IF EXISTS'
Submitted: 17 Apr 2008 16:26 Modified: 22 Oct 2008 10:13
Reporter: Matt Hurley Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S1 (Critical)
Version:1.2.12 OS:Windows
Assigned to: Mike Lischke CPU Architecture:Any

[17 Apr 2008 16:26] Matt Hurley
Description:
After using MySQLMigrationTool.exe, ensuring that the "Do not drop existing schema" has been selected, to create a migration *.lua script and then using grtsh.exe to run this script, the "DROP DATABASE IF EXISTS" is still being called.

The goal is to only migrate two tables out of 20+ tables. Since the "DROP DATABASE IF EXISTS" is called, all of the previously existing tables are dropped and only the two migrated tables are created.

How to repeat:
Use MySQLMigrationTool.exe to create a *.lua migration script that will only migrate a subset of a database's tables. After running MySQLMigrationTool.exe, and before running grtshe.exe, verify (either via the logs or visually checking the database) that the database was not dropped, the previous tables exist, and that the two tables were added.

Use grtshe.exe to run the *.lua migration script. After running grtshe.exe, check the output to verify that "DROP DATABASE IF EXISTS" is called. Check the database to verify that only the small subset of tables have been added, all remaining tables that were ignored no longer exist.

Suggested fix:
None.
[3 Aug 2008 16:48] Sveta Smirnova
Thank you for the report.

Verified as described.
[22 Oct 2008 10:13] Mike Lischke
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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html