@echo off set txt1=%date:~0,4% ::当前年 set txt2=%date:~5,2% ::当前月 set txt3=%date:~8,2% ::当前日 set txt4=%time:~0,2% ::当前小时 set txt5=%time:~3,2% ::当前分钟 set txt6=%time:~6,2% ::当前秒 set date=%txt1%%txt2%%txt3% set time=%txt4%%txt5%%txt6%
echo MySQL Database backup echo about 10 minutes echo don't close this window echo it will close by itself
echo output Database if exist %date%.sql del %date%.sql C:\Mysql\mysql\bin\mysqldump --add-drop-table -c -u root -pweituan -h 202.114.20.62 tuanwei > F:\databack\%date%.sql
if exist dump%date%.7z del dump%date%.7z echo compressed,please wait F:\databack\7za.exe a -t7z dump%date%.7z %date%.sql -mx9
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
