1.建立getFtp_cdn.bat,内容如下(不包括说明):

D:
cd D:\log\cdn\

set ciodate=access_%yesterday%-000000_www.123.cn.log
(echo open 11.11.11.11 21
echo username
echo password
echo get %yesterday%/www.123.cn/%ciodate%.gz
echo bye) > ftp_beifen.src

ftp -s:ftp_beifen.src
echo %date%导出数据库备份结束,时间:%time% >> getftp_beifen.log

2.建立getFtp_cdn.vbs,内容如下(不包括说明):

dtmYesterday = DateAdd("d",-1,Date) //-1,前一天,-2前两天……
strYear = DatePart("yyyy",dtmYesterday)

strYear = right(strYear,2) //格式:081231,如果20090101格式删除此语句!

If DatePart("m",dtmYesterday) < 10 Then
strMonth = 0 & DatePart("m",dtmYesterday)
Else
strMonth = DatePart("m",dtmYesterday)
End If
If DatePart("d",dtmYesterday) < 10 Then
strDay = 0 & DatePart("d",dtmYesterday)
Else
strDay = DatePart("d",dtmYesterday)
End If
strYest = strYear & strMonth & strDay
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run("CMD /K CD D:\cio\CIO & SET yesterday="&strYest&"&getFtp_cio.bat")
Set WshShell = Nothing