Re: Backup onle one procedure

2011-02-10 Thread Ananda Kumar
sorry, my bad. Its -R and not -p. regards anandkl On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang w...@singerwang.comwrote: 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

Re: Backup onle one procedure

2011-02-10 Thread Johan De Meersman
Hmm, I haven't seen the mail from Singer, yet. On Thu, Feb 10, 2011 at 9:33 AM, Ananda Kumar anan...@gmail.com wrote: On Thu, Feb 10, 2011 at 1:58 PM, Singer X.J. Wang w...@singerwang.comwrote: mysqldump -u[user] -p[pass] --where=db=`whatyouwant` and name=`whatyouwant` mysql proc Yes, I

Backup onle one procedure

2011-02-09 Thread Adarsh Sharma
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

Re: Backup onle one procedure

2011-02-09 Thread Johan De Meersman
On Thu, Feb 10, 2011 at 7:43 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: 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

Re: Backup onle one procedure

2011-02-09 Thread Ananda Kumar
there is -p option please used that. On Thu, Feb 10, 2011 at 12:47 PM, Johan De Meersman vegiv...@tuxera.bewrote: 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