mysqlbackup.bat

mysql备份程序,很好很强大,欢迎使用

@echo off

::处理时间小时部分可能出现的空字符
set hour=%time:~0,2%
if "%time:~0,1%"==" " set hour=0%time:~1,1%
set pName=%date:~0,4%%date:~5,2%%date:~8,2%%hour%%time:~3,2%%time:~6,2%

::文件夹不存在则创建
if not exist D:\MysqlBackUp md D:\MysqlBackUp

::备份开始
mysqldump -u root -ptengx -B Mysql >D:\MysqlBackUp\%pName%.sql

::如果系统安装rar则把备份脚本压缩成rar并删除备份脚本
if exist C:\Progra~1\WinRAR\rar.exe cd C:\Program Files\WinRAR\ && rar.exe a -ep D:\MysqlBackUp\%pName%.rar D:\MysqlBackUp\%pName%.sql && del D:\MysqlBackUp\%pName%.sql

::判断是否执行删除，当备份成功才执行
set isDel=0
if exist D:\MysqlBackUp\%pName%.rar set isDel=1 
if exist D:\MysqlBackUp\%pName%.sql set isDel=1

::备份成功则执行删除批处理
if %isDel%==1 call DelBackUp.bat

exit