原理:使用windows任务计划 执行bat脚本
在bat脚本目录中放置以下文件
winrar程序文件夹,upload_db.bat 脚本
upload_db.bat脚本如下:
========================================
@echo off
rem 上面是切换到数据库备份文件夹
echo -----%date%-----[%time%]---->>upload_db.log
rem upload_db.log是自己定义的日志文件
echo 启动Winrar文件压缩程序.....[%time%]>>upload_db.log
echo 开始对数据库文件进行压缩...[%time%]>>upload_db.log
rem 压缩备份文件
%cd%\winrar\winrar a -m5 -r -ag x:\dbbackup\backup_DB_.rar x:\dbbackup\backup_%date:~,4%_%date:~5,2%_%date:~8,2%_*.bak
echo 准备开始FTP上传压缩文件....[%time%]>>upload_db.log
echo open 10.10.10.10>upload.txt
echo username>>upload.txt
echo 123456>>upload.txt
e