List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:February 10 2011 8:33am
Subject:Re: Backup onle one procedure
View as plain text  
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.
>
>
>

Thread
Backup onle one procedureAdarsh Sharma10 Feb
  • Re: Backup onle one procedureJohan De Meersman10 Feb
    • Re: Backup onle one procedureAnanda Kumar10 Feb
Re: Backup onle one procedureAnanda Kumar10 Feb
  • Re: Backup onle one procedureJohan De Meersman10 Feb