Bug #56977 Dump Embeds Database Name in CREATE, USE and CREATE TRIGGER
Submitted: 23 Sep 2010 16:20 Modified: 23 Sep 2010 16:57
Reporter: Larry D. Wilson Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S4 (Feature request)
Version:5.2.27, 5.2.28 OS:Any
Assigned to: CPU Architecture:Any
Tags: dump, option

[23 Sep 2010 16:20] Larry D. Wilson
When using MySQLWorkbench to dump data, it automatically embeds CREATE DATABASE <source> and USE DATABASE <source> statements, and includes the database/schema name for CREATE TRIGGER which implacts it's flexibility in a development environment. 

How to repeat:
Open a Server Administration tab, select "Export to Disk", select the database(s) to export and existing options. There are no options to export without specifying database.

Suggested fix:
Add option to [x] Suppress CREATE DATABASE <source>, USE <source>, and suppress database/schema name on triggers.
[23 Sep 2010 16:57] Valeriy Kravchuk
Thank you for the feature request.