mysql定时备份bat脚本

@echo off
setlocal enabledelayedexpansion

:: 设置MySQL连接参数
set MYSQL_USER=root
set MYSQL_PASSWORD=your_password
set MYSQL_HOST=localhost
set MYSQL_PORT=3306
set MYSQL_DATABASE=your_database

:: 设置备份目录
set BACKUP_DIR=C:\Backup\MySQL
if not exist %BACKUP_DIR% mkdir %BACKUP_DIR%

:: 获取当前日期和时间
for /f "tokens=2-4 delims=/ " %%a in ('date /t') do (
    set YEAR=%%c
    set MONTH=%%a
    set DAY=%%b
)
set TIMESTAMP=!YEAR!!MONTH!!DAY!!TIME:~0,2!!TIME:~3,2!

:: 执行备份命令
mysqldump -u%MYSQL_USER% -p%MYSQL_PASSWORD% -h%MYSQL_HOST% -P%MYSQL_PORT% %MYSQL_DATABASE% > %BACKUP_DIR%\backup_!TIMESTAMP!.sql

:: 压缩备份文件
cd %BACKUP_DIR%
zip backup_!TIMESTAMP!.zip backup_!TIMESTAMP!.sql
del backup_!TIMESTAMP!.sql

echo Backup completed at !TIMESTAMP!
endlocal