Bug #14500 mysqldump + functions or procedures + does not dump them
Submitted: 31 Oct 2005 4:38 Modified: 31 Oct 2005 22:57
Reporter: David Lloyd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.15 OS:MacOS (OS X)
Assigned to: MySQL Verification Team CPU Architecture:Any

[31 Oct 2005 4:38] David Lloyd 
Description:
It seems to me that at the moment, mysldump doesn't dump the structure of functions or procedures; see "How to repeat".

How to repeat:

1. Create any function or procedure
2. myslqdump --opt [database_name]
3. Look for function definitions or procedure definitions
[31 Oct 2005 18:19] MySQL Verification Team 
Please use the --routines flag:

miguel@hegel:~/dbs/5.0> bin/mysqldump -uroot --help
mysqldump  Ver 10.10 Distrib 5.0.16, for suse-linux (i686)
By Igor Romanenko, Monty, Jani & Sinisa
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

<cut>

  -R, --routines      Dump stored routines (functions and procedures).
  --set-charset       Add 'SET NAMES default_character_set' to the output.
[31 Oct 2005 22:57] David Lloyd 
Hi There,

Miguel has explained how I am able to but I am going to resubmit another bug indicating that the option is not displayed in the "man page" for mysqldump.

DSL