批处理文件

rem

rem 设置变量：备份文件名
SET BAK_FILE=%date:~0,4%_%date:~5,2%_%date:~8,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%.sql

rem 当前时间的月份
set month=%date:~5,2%

rem 当前时间的月份减去2
set /a month-=2

rem 当前日期格式 如2013_05
SET BAK_DIR=%date:~0,4%_%date:~5,2%

rem 月份减去2的文件夹名 如2013_03
SET lastlast_BAK_DIR=%date:~0,4%_%month%

rem 输出文件名
@ECHO  %BAK_FILE%
@ECHO  %BAK_DIR%
 
rem 创建文件夹
md D:\myBackup\%BAK_DIR%

rem 删除上上个月的文件夹
rd /s /q D:\myBackup\%lastlast_BAK_DIR%
 
rem 开始做备份

c:
cd C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin

mysqldump -uroot -proot -hlocalhost --character-sets-dir=utf-8 shdhv1  > D:\myBackup\%BAK_DIR%\%BAK_FILE%
 
pause
echo