windows环境下备份mysql脚本

脚本文件：mysql_backup.bat 再增加计划任务定时执行

rem ******MySQL backup start******
@echo off

forfiles /p "D:\Mysql_Backup" /m test_backup_*.sql -d -30 /c "cmd /c del /f @path"

set "Ymd=%date:~0,4%%date:~5,2%%date:~8,2%0%time:~1,1%%time:~3,2%%time:~6,2%"
mysqldump --user=root --password=root123 --all-databases --force > D:\Mysql_Backup\test_backup_%Ymd%.sql

@echo on
rem ******MySQL backup end******