Loading... <p>并不是所有MySQL都运行在Linux下,windows下也需要做例行备份,下面是用bat脚本做自动化备份的例子,大家可以参考下。 <br /> <div class="csharpcode"> <pre class="alt"><span class="lnum"> 1: </span>rem </pre> <pre><span class="lnum"> 2: </span>rem C:\Program Files\WinRAR 需要放到 path 下,才能调用rar cli工具 </pre> <pre class="alt"><span class="lnum"> 3: </span>rem </pre> <pre><span class="lnum"> 4: </span>rem 跳转到工作目录下 </pre> <pre class="alt"><span class="lnum"> 5: </span>f: </pre> <pre><span class="lnum"> 6: </span>cd f:\DBBAK </pre> <pre class="alt"><span class="lnum"> 7: </span>rem 设置变量:备份文件名 </pre> <pre><span class="lnum"> 8: </span>SET BAK_FILE=MY_DBBAK_%date:~0,-4%.sql </pre> <pre class="alt"><span class="lnum"> 9: </span>rem 设置变量:日志文件名 </pre> <pre><span class="lnum"> 10: </span>SET LOG_FILE=MY_DBBAK.log </pre> <pre class="alt"><span class="lnum"> 11: </span>rem 记录日志 </pre> <pre><span class="lnum"> 12: </span>echo <span class="str">"%date%"</span> >> %LOG_FILE% </pre> <pre class="alt"><span class="lnum"> 13: </span>rem 开始做备份 </pre> <pre><span class="lnum"> 14: </span>mysqldump --<span class="kwrd">default</span>-character-set=utf8 -hlocalhost -uroot -R --triggers --single-transaction -B mydb > %BAK_FILE% </pre> <pre class="alt"><span class="lnum"> 15: </span>rem 压缩备份文件 </pre> <pre><span class="lnum"> 16: </span>rar a %BAK_FILE%.rar %BAK_FILE% </pre> <pre class="alt"><span class="lnum"> 17: </span>rem 删除源文件 </pre> <pre><span class="lnum"> 18: </span>del /F %BAK_FILE% </pre> <pre class="alt"><span class="lnum"> 19: </span>echo <span class="str">"%date%"</span> >> %LOG_FILE% </pre> <pre><span class="lnum"> 20: </span>echo <span class="str">""</span> >> %LOG_FILE%</pre> </div> <style type="text/css"> .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; }</style></p> Last modification:October 6, 2023 © Allow specification reprint Support Appreciate the author AliPayWeChat Like 如果觉得我的文章对你有用,请随意赞赏
One comment
和linux里的sh脚本差不多,不过这个感觉语法复杂