mysql备份

利用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命名文件夹