1.新建bat文件
2.拷贝以下代码根据实际情况修改参数
@echo off
setlocal enabledelayedexpansion
rem 准备执行
rem set userdomain
rem 设置文件所在目录
set src_dir=E:\database_backup
rem filename用于存放目标文件名
set filename=""
cd /d %src_dir%
for /f %%a in ('dir /o-d /tc /b ') do (
echo 文件完整信息: %%a
set filename=%%~na%%~xa
echo 文件名: !filename!, 最新创建时间: %%~ta
if not !filename! == "" (
goto iconv
)
)
:iconv
echo %filename%
rem localPath本地上传文件路径
set localPath=E:\database_backup\%filename%
rem ftpip FTPIP
set ftpip=172.23.4.xxx
rem username FTP用户名
set username=hx01
rem password FTP密码
set password=123.com
rem ftpPath FTP内路径
set ftpPath=.\
Echo open %ftpip% >ftp.up
Echo %username%>>ftp.up
Echo %password%>>ftp.up
Echo Cd %ftpPath% >>ftp.up
Echo binary>>ftp.up
Echo put %localPath%>>ftp.up
Echo bye>>ftp.up
FTP -s:ftp.up
del ftp.up /q
:Pause