From: Ananda Kumar
Date: February 10 2011 8:33am
Subject: Re: Backup onle one procedure
List-Archive: http://lists.mysql.com/mysql/224355
Message-Id: <AANLkTimp6jwwXdz+UdZzbtpSsDncmZRAaDV5Z0mRx6FA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e65ae4dc460626049be96e76

--0016e65ae4dc460626049be96e76
Content-Type: text/plain; charset=ISO-8859-1

sorry, my bad.

Its -R and not -p.

regards
anandkl

On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang <wang@stripped>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 <anandkl@stripped> wrote:
>
>> there is -p option please used that.
>>
>> On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman <vegivamp@stripped
>> >wrote:
>>
>> > On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma <
>> adarsh.sharma@stripped
>> > >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.
>
>
>

--0016e65ae4dc460626049be96e76--