MySQL Bugs: #56977: Dump Embeds Database Name in CREATE, USE and CREATE TRIGGER

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:	None
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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

Thank you for the feature request.