利用windows任务计划新建文本文档,
复制整个文件夹
net stop mysql
xcopy "D:\Program Files\MySQL\MySQL Server 5.5\data" E:\程序备份\mysql\%date:~0,4%-%date:~5,2%-%date:~8,2%\ /s
net start mysql
复制文件
net stop mysql
xcopy "D:\Program Files\MySQL\MySQL Server 5.5\data\*.*" E:\程序备份\mysql\%date:~0,4%-%date:~5,2%-%date:~8,2%\ /y
net start mysql
注:%date:~0,4%-%date:~5,2%-%date:~8,2% 是按日期格式YYYY-MM-DD命名文件夹