window 平台下 备份MySQL (脚本)
@echo off
echo -------------------------
echo mysql backup
echo 2014.11.26
echo -------------------------
set jtkd_d=jtkd_d_%date:~0,4%%date:~5,2%%date:~8,2%.sql
set jtkd_accountdb=jtkd_accountdb_%date:~0,4%%date:~5,2%%date:~8,2%.sql
set jtkd_static=jtkd_static_%date:~0,4%%date:~5,2%%date:~8,2%.sql
set jtkd_statistics=jtkd_statistics_%date:~0,4%%date:~5,2%%date:~8,2%.sql
cd D:\Program Files\MySQL\MySQL Server 5.5\bin
mysqldump -uroot -proot --databases jtkd --routines --events --triggers >D:\BACKUP\%jtkd_d%
cd \
cd bat
@echo off
rem pause
本文出自 “SQLServer MySQL” 博客,请务必保留此出处http://dwchaoyue.blog.51cto.com/2826417/1582742
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。