MYSQL数据库备份导出bat代码

把下面代码保存

文件名.bat

@echo off

echo.

echo MySQL数据库备份脚本By osyunwei.com

echo *****************************

echo.

echo 备份日期：%date%

echo 备份时间：%time%

echo.

echo *****************************

set Ymd=%date:~,4%%date:~5,2%%date:~8,2%

md D:\MySQLdata_Bak\mysql\aquanbu

D:\HwsHostMaster\phpweb\mysql\bin\mysqldump --opt -u 数据用户 --password=数据库密码 数据库名称 >D:\MySQLdata_Bak\mysql\aquanbu\bbs_mysql_bak.sql

echo.

echo %Date:~0,4%-%Date:~5,2%-%Date:~8,2% %time:~0,2%:%time:~3,2%:%time:~6,2%  断网已重启，等待延时8秒...>>quan.txt