Menu

#3496 Add option to export stored routines without adding definers

New
nobody
None
Default
Enhancement
2014-01-11
2014-01-11
Anonymous
No

Originally created by: kr.k...@gmail.com

What is the problem that needs to be solved (required)?
When exporting database as sql, each stored routine has added the definer declaration. It is not always good, especially, when exported sql has to be imported to different server. In my case I have development db server available at localhost from webserver, but on the production, db server is available only through Internet. So, everytime I export sql from my development configuration, I have to remove definers before importing it to production.

What is the idea in abstract terms (optional)?
In export panel add a checkbox to turn off adding definers to stored routines.

Example workflow using the new feature (optional)?

What is a practical way to implement this idea (optional)?

Discussion