MySQL Bugs: #57646: Option to ignore DEFINER when importing stored procedures and functions

Bug #57646	Option to ignore DEFINER when importing stored procedures and functions
Submitted:	22 Oct 2010 3:43	Modified:	22 Oct 2010 4:11
Reporter:	Zbigniew Helak	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S4 (Feature request)
Version:	5.2.27	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
This request is complementary to another feature request #57645. 
I would like to be able to export stored procedures from one database (local development) and import them to another database (on-line, production). When I try to do this - import fails due to unacceptable portion of stored procedures DEFINERs exported from local database. 

Currently to only way around is to go to the dump file and manually remove DEFINER's from the dump. Then the file can be imported to the live database.

I would like to have an option to ignore DEFINER's when importing dump file to the database. That would allow me to skip the manual extra step which is required now. 

How to repeat:
Export to disk stored procedures from one, local database and try to import them to the on-line, shared hosting environment like DREAMHOST.COM or others. 

Suggested fix:
I would like to have an option to ignore DEFINER's when importing dump file to the database. That would allow me to skip the manual extra step which is required now.

Thank you for the feature request.

+1