Help needed with automated FTP script - Shell Programming and Scripting

leimrod · #1 (**permalink**) 07-09-2008

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:

Code:

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

This does not work, its just creates a folder named "%Y" with a folder inside it called "%m" with a "%d" folder inside that.

How would I go about creating folders with the date structure above on a the remote windows machine? All advice and help appreciated.

danmero · #2 (**permalink**) 07-09-2008

Code:

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

Franklin52 · #3 (**permalink**) 07-09-2008

Try something like this:

Code:

#!/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

Regards

jyoung · #4 (**permalink**) 07-09-2008

How about this.

Code:

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

leimrod · #5 (**permalink**) 07-10-2008

Quote:

Originally Posted by Franklin52

Try something like this:

Code:

#!/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

Regards

Kudos! That works perfectly

Much appreciated, you've made this Irishman very happy, I have one less job today, lol

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
scp automated script	gholdbhurg	UNIX for Advanced & Expert Users	5	10-27-2008 12:23 AM
How to execute script one by one in automated env	madhusmita	Shell Programming and Scripting	1	07-02-2008 05:16 AM
i want automated script	arghya_owen	Shell Programming and Scripting	3	06-16-2008 09:02 AM
Need help for automated shell script	uneex	Shell Programming and Scripting	4	05-01-2008 12:15 PM
help for automated script	splax	UNIX for Advanced & Expert Users	4	12-26-2006 04:36 PM

Thread Tools	Search this Thread
Show Printable Version 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: