simple auto backup ftp script

backup the data on linux server to windows use this simple script:

 

rem filename : autoftp.bat

rem author : bydgod

rem function : auto download the db bak file with the name of $today.dmp

rem author : bydgod

rem date : 2010.07.04

rem version : v0.0

rem note :  you can add this bat to your XP schedule.

rem mkdir the folder needed (ex. e:/bak/db148) before use this shell

 

rem prepare variables needed

rem modify these variables needed.
set desdir=/home/oracle/bak
set bakdir=e:/bak/db148
set ftpsript=c:/148.ftp

set ip=192.168.1.148

set user=oracle

set pwd=oracle
set today=%date:~0,4%%date:~5,2%%date:~8,2%
set /a oldday=%today%-1

 

rem if these is no enough space then delete the old files
del %bakdir%/%oldday%.dmp

 

rem generate the ftp script
echo open %ip%>%ftpsript%
rem these is no space after the username and pwd
echo %user%>>%ftpsript%
echo %pwd%>>%ftpsript%
echo prompt>>%ftpsript%
echo bin>>%ftpsript%
echo lcd %bakdir%>>%ftpsript%
echo cd %desdir%>>%ftpsript%
echo get %today%.dmp>>%ftpsript%
echo by>>%ftpsript%
ftp -i -s:%ftpsript%

 

rem delete the ftp script file
del %ftpsript%