批量备份： net stop mysql
xcopy D:/Program/MySQL5/data/mysql_name/*.* D:/backup/mysql_name_%date:~0,10%/ /y
xcopy D:/Program/MySQL5/data/mysql_name1/*.* D:/backup/mysql_name1_%date:~0,10%/ /y
xcopy D:/Program/MySQL5/data/mysql_name2/*.* D:/backup/mysql_name2_%date:~0,10%/ /y
net start mysql
c:/progra~1/winrar/winrar a -k -r -s D:/backup/mysql_name_%date:~0,10%.rar D:/backup/mysql_name_%date:~0,10% 内容来自oleou.com
c:/progra~1/winrar/winrar a -k -r -s D:/backup/mysql_name1_%date:~0,10%.rar D:/backup/mysql_name1_%date:~0,10%
c:/progra~1/winrar/winrar a -k -r -s D:/backup/mysql_name2_%date:~0,10%.rar D:/backup/mysql_name2_%date:~0,10%
rd D:/backup/mysql_name_%date:~0,10%/ /S /Q
rd D:/backup/mysql_name1_%date:~0,10%/ /S /Q
rd D:/backup/mysql_name2_%date:~0,10%/ /S /Q
第三种方法【推荐】 net stop mysql
xcopy D:/Program/MySQL5/data/mysql_name/*.* D:/backup/backup_%date:~0,10%/mysql_name/ /y
xcopy D:/Program/MySQL5/data/mysql_name1/*.* D:/backup/backup_%date:~0,10%/mysql_name1/ /y
xcopy D:/Program/MySQL5/data/mysql_name2/*.* D:/backup/backup_%date:~0,10%/mysql_name2/ /y
net start mysql
c:/progra~1/winrar/winrar a -k -r -s D:/backup/backup_%date:~0,10%.rar D:/backup/backup_%date:~0,10%
oleou.com
TAGS：
