利用windows定时任务备份项目

来源：互联网发布：java定义日期变量编辑：程序博客网时间：2024/06/05 10:10

以下本人以win8.1系统下配置为例

1.创建一个backup.bat文件,代码如下:

@echo offset "Ymd=%date:~0,4%%date:~5,2%%date:~8,2%" @echo 开始备份项目源文件XCOPY E:\Project\java\WEB_PWT  F:\backup\yuanzhong%Ymd% /y /e /i@echo 开始备份pb_vms数据库mysqldump --opt -u root --password=ndxfke pb_vms > F:\backup\pb_vms%Ymd%.sql /y /e /i@echo 备份结束@echo on

2.进入【计算机管理】——【系统工具】——【任务计划程序】，执行最右侧的【创建基本任务】——根据向导和自已需求填入相应信息，一路下一步到“您希望执行什么操作?”这里，选择【启动程序】——引入先前写好的backup.bat文件——完成;

3.你进入任务列表，执行运行后查看结果

我的另一段实例.bat文件

@echo off@echo ------------------------------------------------------@echo MYSQL DB_CHAYE Backuping ....@echo ------------------------------------------------------set "YM=%date:~0,4%%date:~5,2%"IF NOT EXIST "D:/Backup_sql/wengxy/%YM%" MD "D:/Backup_sql/wengxy/%YM%"set "backPath=D:/Backup_sql/wengxy/%YM%"set "Ymd=%date:~0,4%%date:~5,2%%date:~8,2%-%time:~0,2%%time:~3,2%%time:~6,2%"mysqldump -uroot -pndxfke db_wengxy >  %backPath%/mysql_wengxy_back_%Ymd%.sql @echo Backed ！@echo on

@echo on@echo --------------PWT 附件自动备份脚本 准备启动 -----------------@echo@echo offset "sourcePath=D:\virtualhost\wengxy2\ROOT\upload"set "targetPath=D:\File_Backup" set "Hmst=%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%%time:~9,2%" set "fileName=wengxy_upload_%Hmst%.rar"IF NOT EXIST "%targetPath%" MD "%targetPath%"start c:\"Program Files (x86)"\winrar\rar a -k -r -s -m1 %targetPath%\%fileName% %sourcePath%@echo@echo -------------- 备份成功 -----------------@echo on

@echo offclsecho ===========================================echo    方友信息科技 POSTGRESQL 自动备份echo    2015-06-13echo ===========================================@set DBName=db_fangyou@set Filename=%DBName%_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2%%time:~9,2%.backup@set Dirname=%date:~0,7%@set Backupdir=D:\backup@set ProgramPath = D:\PostgreSQL\9.3\bin\rem 如果当天是一号则新建新月份目录@if %date:~8,2% == 01 (md %Backupdir%\%Dirname%)rem 如果没有当月目录则新建当月目录@if not exist %Backupdir%\%Dirname% (md %Backupdir%\%Dirname%)rem cd %ProgramPath%rem 执行备份任务%ProgramPath%pg_dump --host localhost --port 5432 --username "postgres" --role "erpdb" --no-password  --format tar --blobs --section pre-data --section data --section post-data --encoding UTF8 --verbose --file %Backupdir%\\"%Dirname%"\\"%Filename%" %DBName%

0 0