批处理备份mysql数据库, 前一段时间要备份mysql的数据，找了半天都没有看到合适的。今天发现了大活这边的例子，呵，还不错。放在网上大家共享。

@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

echo delete temporary files
del %date%.sql

echo backup is successful!

保存为.bat文件，运行即可