写个bat 做任务计划,内容如下:
脚本开始:
@echo off
set THISDATE=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%
forfiles /p "D:/dbbackup" /m *.sql /d -2 /c "cmd /c del @path"
D:
cd D:/Program Files/MySQL/MySQL Server 5.1/bin
mysqldump -ucutebiz -pcutebiz 数据库名称>D:/dbbackup/数据库名称%THISDATE%.sql
echo on
脚本结束: