復制代碼 代碼如下:

[html]
@echo off
echo -------------------------
echo mysql backup
echo 2012.11.18
echo -------------------------
set year=%date:~0,4%
set month=%date:~5,2%
set day=%date:~8,2%
set scx_db=scx_db_%year%%month%%day%.sql
set scxdb_db=scxdb_db_%year%%month%%day%.sql
rem 這里是注釋部分
rem net stop mysql
rem net start mysql
cd D:/Program Files/phpStudy/MySQL/bin
mysqldump -uroot -proot scx >d:/bat/%scx_db%
mysqldump -uroot -proot scxdb>d:/bat/%scxdb_db%
cd /
cd bat
@echo off
rem pause