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 >