@echo off
echo 正在备份数据库
Set name=%date:~0,10%
C:\"Program Files"\MySQL\"MySQL Server 5.0"\bin\mysqladmin -u root --password=gxdzbz shutdown
C:\"Program Files"\MySQL\"MySQL Server 5.0"\bin\mysqldump --opt -u root --password=gxdzbz db > D:\db_backup\%name%.sql
C:\"Program Files"\MySQL\"MySQL Server 5.0"\bin\mysqld-nt
net start mysql
echo .&pause
按照日期作为保存文件名