MySQL 备份脚本文件

@echo off

echo =========MySQL BACKUP=========

:: 设置变量
set "MYSQL_DIR=C:\Program Files\MySQL\MySQL Server 5.6\bin"
set "HOST=127.0.0.1"
set "PORT=3306"
set "USER=root"
set "PASSWD=********"
set "DATABASE=test"
set "BACKUP_DIR=C:\backups"
set "BACKUP_TIME=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%"

:: 进入mysql安装目录的bin目录下
cd %MYSQL_DIR%

:: 执行备份
mysqldump --opt --single-transaction=TRUE --user=%USER% --password="%PASSWD%" --host=%HOST% --port=%PORT% --protocol=tcp --default-character-set=utf8 --databases "%DATABASE%" > %BACKUP_DIR%\backup_%BACKUP_TIME%.sql

:: 保留最近7天的备份文件，删除旧文件。（可选）
forfiles /p %BACKUP_DIR% /m backup_*.sql -d -7 /c "cmd /c del /f @path"

echo =========MySQL BACKUP END=========

@echo on