Frustrated, please help

Dev Shed Forums Sponsor:

June 8th, 2003, 08:21 AM

Junior Member

Join Date: Jun 2003

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

Frustrated, please help

Code:

#!/bin/sh
$DATESTAMP = `date %M-%d-%Y`
/usr/local/bin/mysqldump -ubplan01 -pmypass bplan01 > /home/bplan01/$DATESTAMP-backup.sql

Ok, that runs file from the command line.

Then I have my crontab file:

Code:

6 * * * * /home/bplan01/backup.sh

* * * * * /home/bplan01/overload.pl

I get an email from crond at 6 saying :

Quote:

/home/bplan01/backup.sh: /usr/local/bin/mysqldump: invalid command or file name

Can anyone tell me how to fix this?

June 8th, 2003, 09:50 AM

»» ¤ ««

Join Date: Feb 2003

Location: Indonesia

Posts: 905

Time spent in forums: 20 h 33 m 25 sec
Reputation Power: 6

I'm not good at linux-scripting, but what happened if you try to run the backup.sh manually ?

June 8th, 2003, 10:34 AM

Sepodati

Banned

Join Date: Dec 1999

Location: Afghanistan

Posts: 14,381

Time spent in forums: 2 Months 4 Weeks 7 h 22 m 14 sec
Reputation Power: 1784

What does this have to do with PHP? Moving this to Linux, I guess...

---John Holmes...

June 11th, 2003, 04:19 PM

hubris, loathing, technology

Join Date: May 2001

Location: http://frymaster.ca

Posts: 76

Time spent in forums: 1 h 27 m 57 sec
Reputation Power: 8

dumb question ... is mysqldump in /usr/local/bin? maybe in /usr/local/mysql/bin/ ?

Viewing: Dev Shed Forums > Operating Systems > Linux Help > Frustrated, please help

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump