rem 数据库备份策略:
@echo off
set hour=%time:~0,2%
if "%time:~0,1%"==" " set hour=0%time:~1,1%
rem 格式化时间格式
set now=%Date:~0,4%%Date:~5,2%%Date:~8,2%%hour%%Time:~3,2%%Time:~6,2%
echo %now%
rem 压缩应用(winrar安装路径)
set rar_file="C:\Program Files\WinRAR\WinRAR.exe"
rem mysql安装路径
set mysql_home="D:\Program Files\MySQL\MySQL Server 5.6"
set host=127.0.0.1
set port=3306
set user=root
set pass=root
rem 数据库地址(保留设置,未使用)
set dbname=omc_platform
rem 新建文档backup
md backup
rem 备份文档名称
set backupfile=D:\backup\%dbname%-%now%.sql
rem 压缩文档名称
set backupRAR=D:\backup\omc_dbBackup-%now%.rar
rem 执行备份命令导出数据库脚本
%mysql_home%\bin\mysqldump -h%host% -P%port% -u%user% -p%pass% %dbname% > %backupfile%
rem 删除老的备份
rem forfiles 参数:/p 搜索路径,/m 搜索文件类型,/d -数字 搜索大于多少天数的文件,/c "