bat备份数据库通过ftp上传

Others
发布于 2018-05-28 06:14:04 2673 次浏览

A文件中的代码: 

rem 将每天备份的数据压缩后导入到ftp服务器 @echo off set dateStr=%date:~0,4%%date:~5,2%%date:~8,2% echo 压缩备份文件 set path=%path%;D:\Program Files\WinRAR;
rar a e:\databak\2011_%dateStr%.rar e:\databak\*.bak echo 上传文件
ftp -n < d:\task\B.ftp echo 删除多余文件 del e:\databak\*.bak del e:\databak\*.rar 

    
    

    <li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    1
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    2
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    3
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    4
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    5
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    6
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    7
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    8
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    9
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    10
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    11
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    12
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    13
</li>

<li style="box-sizing:border-box;outline:0px;padding:0px 8px;margin:0px;list-style:none;word-break:break-all;color:#999999;">
    14
</li>

B.ftp文件中的代码： 

open ftp服务器的Ip
user 用户名 密码 put e:\databak\*.rar
quit
目录