window bat脚本 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%
::设置当前mysql路径
set mysql_path="C:\Program Files\MySQL\MySQL Server 5.0"
::设置当前mysql bin路径
set mysql_path_bin=%mysql_path%\bin
::设置opt_mysql
set opt_mysql=--add-drop-database --add-drop-table
set back_file="D:\MySQLData"
echo MySQL Database backup
echo about 10 minutes
echo don't close this window
echo it will close by itself
echo output Database
:: mysql安装bin路径 %mysql_path_bin%\mysqldump
:: mysql备份文件路径%back_file%\%date%%time%.sql
::备份test数据库
ECHO 开始备份test数据库
if exist %date%%time%.sql del %date%%time%.sql
%mysql_path_bin%\mysqldump %opt_mysql% -c -u root -pliyong test > %back_file%\%date%%time%.sql
::将备份的"%date%%time%.sql"进行rar压缩。
"C:\Program Files\WinRAR\rar" a "D:\MySQLData\%date%%time%.sql.rar" "D:\MySQLData\%date%%time%.sql"
:: 删除备份的源文件
del "D:\MySQLData\%date%%time%.sql"
pause
======================================================


window mysq：l 热恢复


@echo off


::文件路径

 D:\MySQLData\20110623163403.sql
mysql -u root -pliyong test