Bug #55718 Feature Request: Enable stored routine backups by default with mysqldump
Submitted: 3 Aug 2010 15:52 Modified: 3 Aug 2010 15:57
Reporter: Brian Downey Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[3 Aug 2010 15:52] Brian Downey 
Description:
By /default/ a "drop database" will also removed its associated stored routines from the mysql.proc table (as it should).   

However it is not /default/ to back up said stored routines with mysqldump.   It is an option that must be specified on the command line (--routines).

It's simply a documentation/administrator awarness thing--but it would be nice to have a cohesive approach to destroying and backing up stored routines, which would also act a safety net for MySQL DBAs, since stored routines are realtively new to many of them.

How to repeat:
Drop a database utilizing store routines, then look for them in a standard, un-optioned "mysqldump" of said database.

Suggested fix:
Just make --routines a default behavior of mysqldump
[3 Aug 2010 15:55] Paul DuBois 
This is also true for Event Scheduler events:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump-stored-programs.html
[3 Aug 2010 15:57] Valeriy Kravchuk 
Thank you for the feature request.