@title MySQL备份脚本
@echo off
@echo root@127.0.0.1:3306
set host=127.0.0.1
set port=3306
set user=root
@echo 请输入数据库密码
set /p password=
@echo 请输入需要备份的数据库
@set /p database=
set mysqldumppath=d:\mysql\bin
set resultfilepath=e:
set curdate=%date:~0,4%-%date:~5,2%-%date:~8,2%
set curmon=%date:~0,4%%date:~5,2%
set curtime=%time:~0,2%
if "%curtime%"=="0" set curtime=00
if "%curtime%"=="1" set curtime=01
if "%curtime%"=="2" set curtime=02
if "%curtime%"=="3" set curtime=03
if "%curtime%"=="4" set curtime=04
if "%curtime%"=="5" set curtime=05
if "%curtime%"=="6" set curtime=06
if "%curtime%"=="7" set curtime=07
if "%curtime%"=="8" set curtime=08
if "%curtime%"=="9" set curtime=09
set curtime=%curtime%-%time:~3,2%-%time:~6,2%
set resultfile=%database%_%curdate%_%curtime%.sql
@%mysqldumppath%\mysqldump.exe %database% --result-file=%resultfilepath%\%resultfile% --complete-insert --user=%user% --password=%password% --host=%host% --port=%port%
@echo 操作结束
pause
@echo on
exit
可以简单修改下脚本将要输入的内容写定,加入计划任务中,每次开机自动备份一次MySQL数据库。