脚本如下,把脚本制定成计划任务即可
@echo off title 数据库备份 set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" "E:Program FilesMySQLMySQL Server 5.5inmysqldump" --opt -u root --password=ROOT erdpc > F:备份数据库erdpc_%Ymd%.sql
脚本如下,把脚本制定成计划任务即可
@echo off title 数据库备份 set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" "E:Program FilesMySQLMySQL Server 5.5inmysqldump" --opt -u root --password=ROOT erdpc > F:备份数据库erdpc_%Ymd%.sql