@echo off
set USER=root
set PASSWORD=root
set DATABASE=**
rem 备份文件存储路径
set BACKUP_DIR=f:\DMP_BACKUP\dmp_backup
rem 备份文件目录 处理小时
set h=%time:~0,2%
set h=%h: =0%
set DUMPFILE=%date:~0,4%%date:~5,2%%date:~8,2%-%h%%time:~3,2%_dmp.sql
set OPTIONS=-u%USER% -p%PASSWORD% %DATABASE%
set DATE_TIME=%date:~0,4%-%date:~5,2%-%date:~8,2% %time:~0,2%:%time:~3,2%:%time
sql数据库定期备份并上传ftp脚本
最新推荐文章于 2024-03-01 17:10:44 发布