sorry, my bad. Its -R and not -p.
regards anandkl On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang <w...@singerwang.com>wrote: > Remember that procedure is defined per database, > > mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and > name=`whatyouwant`" mysql proc > > > On Thu, Feb 10, 2011 at 02:55, Ananda Kumar <anan...@gmail.com> wrote: > >> there is -p option please used that. >> >> On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman <vegiv...@tuxera.be >> >wrote: >> >> > On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma < >> adarsh.sha...@orkash.com >> > >wrote: >> > >> > > I am researching all the ways to backup in mysql and donot able to >> find a >> > > command that take individual backup of only one procedure in mysql. >> > > >> > >> > Have a look at the SHOW CREATE PROCEDURE syntax. It's not mysqldump, but >> it >> > will yield a statement that can recreate the given procedure from >> scratch. >> > >> > >> > -- >> > Bier met grenadyn >> > Is als mosterd by den wyn >> > Sy die't drinkt, is eene kwezel >> > Hy die't drinkt, is ras een ezel >> > >> > > -- > The best compliment you could give Pythian for our service is a referral. > > >