Windows下实现mysql定时备份
1、写MySQL备份bat处理
@echo off set "yMd=%date:~,4%%date:~5,2%%date:~8,2%" set "hms=%time:~,2%%time:~3,2%%time:~6,2%" "C:/Program Files (x86)/MySQL/MySQL Server 5.5/bin/mysqldump.exe" -uroot -p123456 demo>D:/mysql_backup_%yMd%-%hms%.sql @echo on
2、打开Windows的任务计划