windows服务器定时备份数据库和代码

1. 写mysqlbackup.bat

@echo off
forfiles /p "F:\mysql_backup" /m "db_*.sql" -d -30 /c "cmd /c del /f @path"
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
"F:\phpstudy\PHPTutorial\MySQL\bin"\mysqldump --opt -u root --password=123456 -h127.0.0.1 think_product > F:\mysql_backup\db_%Ymd%.sql
@echo on

2. 写codebackup.bat

@echo off
forfiles /p "F:\mysql_backup" /m "db_*.sql" -d -60 /c "cmd /c del /f @path"
"C:\Program Files\WinRAR\WinRAR.exe" a "F:\mysql_backup\code_%Date:~0,4%%Date:~5,2%%Date:~8,2%.zip" "F:\product\zwy-1"
@echo on

3. 加入windows定时任务计划

数据库每日备份一次,清除30天之前的历史备份

代码每七天备份一次，清楚60天之前的历史备份