禅道数据库备份

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%
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.