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
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
09 -uroot -p10301 exam < exam3.sql
tomcat启动一分钟后启动bat脚本
@echo off
ping -n 60 127.0.0.1
net start Exam
net start SCK
exit