win下mysql数据库自动备份

@echo off
setlocal

REM 设置备份相关参数
set DB_HOST=localhost
set DB_PORT=3306
set DB_USER=root
set DB_PASSWORD=your_password
set DB_NAME=your_database
set BACKUP_DIR=C:\backup

REM 获取当前日期和时间作为备份文件名的一部分
for /f "tokens=1-3 delims=/" %%a in ('echo %date%') do set "datestr=%%c-%%a-%%b"
for /f "tokens=1-2 delims=:" %%a in ('echo %time%') do set "timestr=%%a-%%b"

REM 执行备份命令
mysql -h%DB_HOST% -P%DB_PORT% -u%DB_USER% -p%DB_PASSWORD% %DB_NAME% > %BACKUP_DIR%\%DB_NAME%_%datestr%_%timestr%.sql

REM 如果备份文件大于0字节，则说明备份成功
if %errorlevel% equ 0 (
  echo Backup successful!
) else (
  echo Backup failed!
)

endlocal