禅道备份

禅道数据库备份

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%