{"id":172,"date":"2016-10-25T16:06:46","date_gmt":"2016-10-25T08:06:46","guid":{"rendered":"http:\/\/www.cxybj.com\/?p=172"},"modified":"2016-10-25T16:06:46","modified_gmt":"2016-10-25T08:06:46","slug":"mysql-%e8%87%aa%e5%8a%a8%e5%a4%87%e4%bb%bd-shell-%e8%84%9a%e6%9c%ac","status":"publish","type":"post","link":"https:\/\/www.cxybj.com\/?p=172","title":{"rendered":"MySQL \u81ea\u52a8\u5907\u4efd Shell \u811a\u672c"},"content":{"rendered":"<pre>#!\/bin\/bash\r\n\r\n# \u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d\uff0c\u591a\u4e2a\u6570\u636e\u5e93\u7528\u7a7a\u683c\u5206\u5f00\r\ndatabases=(db1 db2 db3) \r\n\r\n# \u5907\u4efd\u6587\u4ef6\u8981\u4fdd\u5b58\u7684\u76ee\u5f55\r\nbasepath='\/root\/backup\/b3log.org\/mysql\/'\r\n\r\nif [ ! -d \"$basepath\" ]; then\r\n  mkdir -p \"$basepath\"\r\nfi\r\n\r\n# \u5faa\u73afdatabases\u6570\u7ec4\r\nfor db in ${databases[*]}\r\n  do\r\n    # \u5907\u4efd\u6570\u636e\u5e93\u751f\u6210SQL\u6587\u4ef6\r\n    \/bin\/nice -n 19 \/usr\/bin\/mysqldump -uUSER -pPASSWORD --database $db &gt; $basepath$db-$(date +%Y%m%d).sql\r\n    \r\n    # \u5c06\u751f\u6210\u7684SQL\u6587\u4ef6\u538b\u7f29\r\n    \/bin\/nice -n 19 tar zPcf $basepath$db-$(date +%Y%m%d).sql.tar.gz $basepath$db-$(date +%Y%m%d).sql\r\n    \r\n    # \u5220\u96647\u5929\u4e4b\u524d\u7684\u5907\u4efd\u6570\u636e\r\n    find $basepath -mtime +7 -name \"*.sql.tar.gz\" -exec rm -rf {} \\;\r\n  done\r\n\r\n  # \u5220\u9664\u751f\u6210\u7684SQL\u6587\u4ef6\r\n  rm -rf $basepath\/*.sql\r\n\r\n\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash # \u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\u540d\uff0c\u591a\u4e2a\u6570\u636e\u5e93\u7528\u7a7a &hellip; <a href=\"https:\/\/www.cxybj.com\/?p=172\" class=\"more-link\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,4,5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.cxybj.com\/index.php?rest_route=\/wp\/v2\/posts\/172"}],"collection":[{"href":"https:\/\/www.cxybj.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cxybj.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cxybj.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cxybj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=172"}],"version-history":[{"count":1,"href":"https:\/\/www.cxybj.com\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":173,"href":"https:\/\/www.cxybj.com\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions\/173"}],"wp:attachment":[{"href":"https:\/\/www.cxybj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cxybj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cxybj.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}