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

原文地址:https://www.cnblogs.com/BiakeChou/p/3006736.html