windows下mysql自动备份恢复脚本文件

windows mysql自动备份bat文件

 

@echo off
set path=F:\pmph\exam\mysql\bin;%path%
rem 设置变量：备份文件名

SET BAK_FILE=EXAM_DBBAK_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.sql

rem 设置变量：日志文件名

SET LOG_FILE=EXAM_DBBAK_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log
rem 记录日志
echo "%date%" >> %LOG_FILE%
rem 开始做备份
mysqldump --default-character-set=utf8 -hlocalhost -port3311 -uroot -p10301  exam > E:\databasebak\exam\%BAK_FILE%
echo "%date%" >> %LOG_FILE%

exit

 

 

mysql数据库备份 

D:\pmph\exam\mysql\bin>mysqldump -hlocalhost -port3311 -uroot --default-characte
r-set=utf8  -p10301 exam >exam3.sql

恢复前要在恢复的数据库上新建好数据库名称 指定好字符集

mysql数据库恢复

D:\sck2012\sck\mysql\bin>mysql --default-character-set=utf8  -hlocalhost -port33
09 -uroot  -p10301 exam < exam3.sql

 

 

tomcat启动一分钟后启动bat脚本

@echo off

ping  -n 60 127.0.0.1

net start Exam
net start SCK

exit