1 rem 设置数据库参数
2 @set dbname=sterp
3 @set tmp_db_file="G:\databack\erp\%date:~0,10%.sql"
4 @set db_back_file="G:\databack\erp\%date:~0,10%.rar"
5
6 rem 设置ftp服务器登录参数
7 @set ftp_server=116.141.145.79
8 @set ftp_user=upload
9 @set ftp_password=159357
10
11 rem 备份数据库,以日期为命名
12 mysqldump %dbname% >%tmp_db_file%
13 c:\progra~1\winrar\winrar a -k -r -s %db_back_file% %tmp_db_file%
14 del %tmp_db_file% /S /Q
15
16 rem 通过FTP上传到远处服务器
17 @echo off
18 echo open %ftp_server%>ftp.txt
19 echo %ftp_user%>>ftp.txt
20 echo %ftp_password%>>ftp.txt
21 echo cd erp>>ftp.txt
22 echo put %db_back_file%>>ftp.txt
23 echo bye>>ftp.txt
24 ftp -s:ftp.txt
25 echo 上传成功!
26
27 rem 关鸡
28 shutdown -s -f
2 @set dbname=sterp
3 @set tmp_db_file="G:\databack\erp\%date:~0,10%.sql"
4 @set db_back_file="G:\databack\erp\%date:~0,10%.rar"
5
6 rem 设置ftp服务器登录参数
7 @set ftp_server=116.141.145.79
8 @set ftp_user=upload
9 @set ftp_password=159357
10
11 rem 备份数据库,以日期为命名
12 mysqldump %dbname% >%tmp_db_file%
13 c:\progra~1\winrar\winrar a -k -r -s %db_back_file% %tmp_db_file%
14 del %tmp_db_file% /S /Q
15
16 rem 通过FTP上传到远处服务器
17 @echo off
18 echo open %ftp_server%>ftp.txt
19 echo %ftp_user%>>ftp.txt
20 echo %ftp_password%>>ftp.txt
21 echo cd erp>>ftp.txt
22 echo put %db_back_file%>>ftp.txt
23 echo bye>>ftp.txt
24 ftp -s:ftp.txt
25 echo 上传成功!
26
27 rem 关鸡
28 shutdown -s -f