Re: mysqldump from cron > empty file

2003-10-07 Thread Patrick Larkin
On Monday, October 6, 2003, at 05:11 PM, Paul DuBois wrote: I don't understand. Here you say that mysqldump is in the path, but above you say that you don't know if mysqldump is in the path for cron jobs. I suggest you change the crontab entry to invoke mysqldump by its full pathname and then s

Re: mysqldump from cron > empty file

2003-10-06 Thread Jacco van Schaik
So then Paul DuBois says... > One way to set the path would be to place your mysqldump command in > a helper script: > > #! /bin/sh > export PATH=your-path-setting-here > mysqldump > > Then invoke the helper script from the crontab, rather than invoking > mysqldump directly. You can set the P

Re: mysqldump from cron > empty file

2003-10-06 Thread Paul DuBois
At 17:09 -0400 10/6/03, Patrick Larkin wrote: On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote: Please reply to [EMAIL PROTECTED] (not to me personally), so that others can follow this discussion. At 16:56 -0400 10/6/03, Patrick Larkin wrote: On Monday, October 6, 2003, at 04:37 PM, Paul

Re: mysqldump from cron > empty file

2003-10-06 Thread Patrick Larkin
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote: Please reply to [EMAIL PROTECTED] (not to me personally), so that others can follow this discussion. At 16:56 -0400 10/6/03, Patrick Larkin wrote: On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote: Does the PATH setting for jobs

Re: mysqldump from cron > empty file

2003-10-06 Thread Paul DuBois
Please reply to [EMAIL PROTECTED] (not to me personally), so that others can follow this discussion. At 16:56 -0400 10/6/03, Patrick Larkin wrote: On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote: Does the PATH setting for jobs run by cron include the directory where mysqldump is located

Re: mysqldump from cron > empty file

2003-10-06 Thread Paul DuBois
At 16:33 -0400 10/6/03, Patrick Larkin wrote: Hello - I have the following command to back up a MySQL database on a remote machine. Works beautifully from the command line when run manually as root: mysqldump -h 192.227.20.50 -u root --password=yourmama --opt my_database > /Dumps/my_database.d

mysqldump from cron > empty file

2003-10-06 Thread Patrick Larkin
Hello - I have the following command to back up a MySQL database on a remote machine. Works beautifully from the command line when run manually as root: mysqldump -h 192.227.20.50 -u root --password=yourmama --opt my_database > /Dumps/my_database.dump This results is a nifty SQL file with da