Hmm, I haven't seen the mail from Singer, yet.
On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar wrote:
> On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang wrote:
>
>> mysqldump -u[user] -p[pass] --where="db=`whatyouwant` and
>> name=`whatyouwant`" mysql proc
>>
>
Yes, I thought of that, too; but th
sorry, my bad.
Its -R and not -p.
regards
anandkl
On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang 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, Anand
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 i
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 statem
Dear all,
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.
I know this command and it needs some modification. Please help.
mysqldump -h192.168.0.10 -uroot -porkash --routines --no-create-info
--no-d
