Topic "automation"

Author Message
IanS
[View user's profile]

Joined: 2012-08-13
Posts: 1
I am a total novice here, read (tried to) some of the help files, and am now completely confused.

I need to download a backup of a database twice a week with simple FTP. I have set that up in Windows Tasks (Windows 7), no problem. It starts the winscp application no problem.
but then... I have the script as follows, each command is on a seperate line: User name, password,cd location (which file to look in on the server), lcd location (where to put the downloaded file), prompt, mget xxxxxxx.db, close, quit.

Where do I put this script so that it will actually open winSCP and download the database, and do I need to add/remove bits from it?
the initial session on WinSCP was saved as a default.
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24530
Location: Prague, Czechia
Please start by reading basic guides:
http://winscp.net/eng/docs/guide_automation
http://winscp.net/eng/docs/guide_schedule

Your script will look like:
option batch on
option confirm off
open ftp://username:password@hostname/
cd location
lcd location
get xxxxxxx.db
exit
andegre
[View user's profile]

Joined: 2012-08-20
Posts: 5
In your Windows Task Scheduler, the command that needs to be run should look something like this:

"C:\Program Files\WinSCP\WinSCP.com" /script="yourscript.txt"[/quote]
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License