Windows 自动备份脚本(原创)

@echo off
title FTP备份
echo Wscript.echo dateadd("d",-0,date)>time.vbs
for /f %%a in ('cscript //nologo time.vbs') do del time.vbs&&set datetime=%%a
echo Wscript.echo dateadd("d",-5,date)>time.vbs
for /f %%a in ('cscript //nologo time.vbs') do del time.vbs&&set datetime-5=%%a
echo Wscript.echo dateadd("d",-6,date)>time.vbs
for /f %%a in ('cscript //nologo time.vbs') do del time.vbs&&set datetime-6=%%a
echo Wscript.echo dateadd("d",-7,date)>time.vbs
for /f %%a in ('cscript //nologo time.vbs') do del time.vbs&&set datetime-7=%%a
:--------------------------------------------------------------------------------

:MYSQL帐号
set mysql_user=root
:MYSQL密码
set mysql_pass=MYSQL密码
:MYSQL数据库名
set mysql_data=wzh
:备份目录
set backup=C:\backup\
:网站目录
set wwwroot=C:\wzh\
:调用文件目录
set mysqlfile=C:\wamp\bin\mysql\mysql5.5.24\bin
set winrarfile=C:\Program Files\WinRAR\
:--------------------------------------------------------------------------------
:创建备份目录
if not exist %backup% md %backup%
:备份数据库
path %mysqlfile%;%path%
mysqldump -u%mysql_user% -p%mysql_pass% %mysql_data%>%backup%mysql_%mysql_data%_"%datetime%".sql
:备份网站
path %winrarfile%;%path%
WinRAR a -k -r -s %backup%wwwroot_"%datetime%".rar "%wwwroot%"
:打包网站和数据库
path %winrarfile%;%path%
WinRAR a -k -r -df -p"rar压缩密码" %backup%backup_"%datetime%".rar %backup%wwwroot_"%datetime%".rar %backup%mysql_%mysql_data%_"%datetime%".sql
:删除本地5天前的文件
del /f /s /q %backup%backup_"%datetime-5%".rar
del /f /s /q %backup%backup_"%datetime-6%".rar
del /f /s /q %backup%backup_"%datetime-7%".rar

:FTP上传备份文件，删除5天前的FTP文件
del /f /s /q %temp%\ftp.txt
echo open ftp.wzh.pw 21>>"%temp%\ftp.txt"
echo user backup>>"%temp%\ftp.txt"
echo FTP密码>>"%temp%\ftp.txt"
echo binary>>"%temp%\ftp.txt"
echo del backup_%datetime-5%.rar>>"%temp%\ftp.txt"
echo del backup_%datetime-6%.rar>>"%temp%\ftp.txt"
echo del backup_%datetime-7%.rar>>"%temp%\ftp.txt"
echo put %backup%backup_"%datetime%".rar>>"%temp%\ftp.txt
echo bye>>"%temp%\ftp.txt"
ftp -n -s:"%temp%\ftp.txt"
del /f /s /q %temp%\ftp.txt
exit

PS：转载请注明地址，谢谢