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
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
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
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
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
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,
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 PATH in