getting dump of stored procedure
 

hi all...

mysqldump -u root <databasename> > ~/path/to/store/dump

is used to get entire database dump..can i see the stored procedure code...this way...can anyone suggest me please....

Thanks in advance.....

man mysqldump

I've recently found it in there, so I suggest you do a search in the man page (not at hand at this moment).

Ah, got it (internet is your friend)
option --routines

This is not working ...
i tried in several ways....

mysqldump -u root <databasename> --routines <storedprocedurename> > ~/Desktop/dump.sql

What I understand from the man page is that --routines does not take an argument. So my guess is that it just dumps all stored procedures.

That does not help us to help you. How is it not working (error messages?) ?