禅道数据库备份
if "%OS%" == "Windows_NT" setlocal
@echo off
rem ------------------------------------------------------
rem Start script for the MySQL Server
rem ------------------------------------------------------
set "year=%date:~0,4%"
set "month=%date:~5,2%"
set "day=%date:~8,2%"
set "MYSQL_HOME=D:\zentao\usr\local\mysql\bin"
set "db_backup=zentao_db_%year%%month%%day%.sql"
echo ----------------------------------
echo mysql backup
echo backup time: %year%.%month%.%day%
echo ----------------------------------
if not exist D:\zentao\back @md D:\zentao\back
set path=%Path%;%MYSQL_HOME%
mysqldump -uroot -proot zentao >D:\zentao\back\%db_backup%