Hi,

Ok, i'm trying to automate sending a DB backup from a linux box to a remote Windows PC via FTP. I can connect, send the file and create a folder, however I require that the backups be differentiated by date. Here is what my script looks like:

open *.*.*.*
user username password
lcd /location/of/DB/backup
mkdir %Y/%m/%d
cd %Y/%m/%d
put test.txt
bye
quit

.......
test ! -d `date "+%Y/%m/%d"` && mkdir -p `date "+%Y/%m/%d"`
cd `date "+%Y/%m/%d"`
.......

Try something like this:

#!/bin/sh

Y=`date "+%Y"`
m=`date "+%m"`
d=`date "+%d"`

cd /location/of/DB/backup

ftp -i -n <<EOF
open "hostname"
user "user" "passwd"
mkdir "$Y"/"$m"/"$d"
cd "$Y"/"$m"/"$d"
put test.txt
quit
EOF

Kudos! That works perfectly Much appreciated, you've made this Irishman very happy, I have one less job today, lol

How about this.

file_date=$(date +%m%d%Y)
ftp -in 0.0.0.0 <<E-O-F
user username password
type ascii
mkdir $file_date
cd $file_date
put somefile
quit
E-O-F