Windows下实现mysql定时备份

1、写MySQL备份bat处理

@echo offset \"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的任务计划