ftp via cron

madhavr · 06-13-2007, 12:04 PM

hello,

im trying to ftp my database dump file automatically.

just to clarify the cron works fine.

the contents of the script looks like below:

Quote:

#!/bin/sh

date=`date '+%d-%m-%y'`

mysqldump -A --user=user--password=pass| /usr/bin/bzip2 -c > /home/backup/db/$date.sql.bz2

ftp -in $server <<EOF

quote USER $username

quote PASS $password

prompt

binary

mput /home/backup/db/*

quit

EOF

the server, username and password are all entered directly but i've just replaced them with dummy variables to show this script.

this does the dump fine but never does the ftp part. however if i copy and run this directly via ssh console it works fine. i dont know which log file i should be looking at for possible errors as i dont see one for ftp in /var/log/.

any help would be much appreciated.

DotHQ · 06-13-2007, 12:32 PM

I've had trouble with scripts running out of crontab if I did not put the full qualified path for stuff. I notice you do not have the fully qualified path for ftp ...mysqldump is working from cron without the full path, so it must be okay.

you should have a /var/log/cron
and /var/log/messages

either of those log files might help you further debug the issue.

p_s_shah · 06-14-2007, 12:01 AM

Password is passed wrongly. You can's use <i> PASS $PASS </i>, while you are using non interactive FTP.

Try following :

Code:

ftp -n -d -v $ftphost << END | tee /tmp/ftplog.txt
user $ftpuser $ftppass
prompt
binary
mput /home/backup/db/*
bye
END

If you still find problem, you can check ftp log in /tmp/ftplog.txt

Please check similar thread :
http://www.linuxquestions.org/questi...d.php?t=550671

gtparks · 06-17-2007, 04:34 AM

If you use a ~/.netrc file, you can avoid all the password stuff (it's kept in the .netrc file). The "| tee" scheme is great for debugging. I'd suggest adding "2>&1 | tee" to capture stderr as well as stdout.