From: Ananda Kumar Date: February 10 2011 7:55am Subject: Re: Backup onle one procedure List-Archive: http://lists.mysql.com/mysql/224354 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e65ae4dc4669aa049be8e7da --0016e65ae4dc4669aa049be8e7da Content-Type: text/plain; charset=ISO-8859-1 there is -p option please used that. On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman wrote: > On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma >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 > --0016e65ae4dc4669aa049be8e7da--