批处理备份mysql数据库

@echo off
if %time:~0,2% leq 9 (set hour=0%time:~1,1%) else (set hour=%time:~0,2%)
set filename_tmp=%date:~0,4%%date:~5,2%%date:~8,2%%hour%%time:~3,2%%time:~6,2%
echo %filename_tmp%
mysqldump -h localhost -u root -p --databases db1 db2 > e:/dbbackup/db1_db2%filename_tmp%.sql
echo "恭喜您，备份成功！"
pause