{"id":403,"date":"2012-06-07T15:32:44","date_gmt":"2012-06-07T07:32:44","guid":{"rendered":"http:\/\/elon.852128.com\/blog\/?p=403"},"modified":"2012-06-08T08:24:27","modified_gmt":"2012-06-08T00:24:27","slug":"linux-%e6%8c%89%e7%85%a7%e6%97%a5%e6%9c%9f%e6%97%b6%e9%97%b4%e5%88%9b%e5%bb%ba%e6%96%87%e4%bb%b6%e5%a4%b9","status":"publish","type":"post","link":"https:\/\/elon.852128.com\/blog\/2012\/06\/07\/linux-%e6%8c%89%e7%85%a7%e6%97%a5%e6%9c%9f%e6%97%b6%e9%97%b4%e5%88%9b%e5%bb%ba%e6%96%87%e4%bb%b6%e5%a4%b9\/","title":{"rendered":"linux \u6309\u7167\u65e5\u671f\u65f6\u95f4\u521b\u5efa\u6587\u4ef6\u5939"},"content":{"rendered":"<p>mkdir \/home\/admin\/htdocs\/`date &#8216;+%Y-%m-%d-%H:%M&#8217;` #\u6628\u5929\u65e5\u671f date &#8216;+%Y%m%d&#8217; -d &#8216;1 days ago&#8217;<\/p>\n<p>\u5229\u7528\u7cfb\u7edfcrontab\u6765\u5b9a\u65f6\u6267\u884c\u5907\u4efd\u6587\u4ef6\uff0c\u6309\u65e5\u671f\u5bf9\u5907\u4efd\u7ed3\u679c\u8fdb\u884c\u4fdd\u5b58\uff0c\u8fbe\u5230\u5907\u4efd\u7684\u76ee\u7684\u3002 <\/p>\n<p>\u3000\u30001\u3001\u521b\u5efa\u4fdd\u5b58\u5907\u4efd\u6587\u4ef6\u7684\u8def\u5f84\/mysqldata <\/p>\n<p>\u3000\u3000#mkdir \/mysqldata <\/p>\n<p>\u3000\u30002\u3001\u521b\u5efa\/usr\/sbin\/bakmysql\u6587\u4ef6 <\/p>\n<p>\u3000\u3000#vi \/usr\/sbin\/bakmysql <\/p>\n<p>\u3000\u3000\u8f93\u5165 <\/p>\n<p>\u3000\u3000rq=` date +%Y%m%d `  <\/p>\n<p>\u3000\u3000tar zcvf \/mysqldata\/mysql$rq.tar.gz \/var\/lib\/mysql <\/p>\n<p>\u3000\u3000\u6216\u8005\u5199\u6210 <\/p>\n<p>\u3000\u3000rq=` date +%Y%m%d ` <\/p>\n<p>\u3000\u3000mysqldump &#8211;all-databases -u root -p\u5bc6\u7801 > \/mysqldata\/mysql$rq.sql <\/p>\n<p>  \u6ce8\u610f\uff1a`\u7b26\u53f7\u662fTAB\u952e\u4e0a\u9762\u7684\u7b26\u53f7\uff0c\u4e0d\u662fENTER\u5de6\u8fb9\u7684 <\/p>\n<p>\u3000\u3000\u8fd8\u6709date\u540e\u8981\u6709\u4e00\u4e2a\u7a7a\u683c\u3002<\/p>\n<p>\u3000\u3000\/var\/lib\/mysql\u662f\u4f60\u6570\u636e\u5e93\u6587\u4ef6\u7684\u76ee\u5f55\uff0c\u90e8\u5206\u7528\u6237\u662f\/usr\/local\/mysql\/data\uff0c\u6bcf\u4e2a\u4eba\u53ef\u80fd\u4e0d\u540c <\/p>\n<p>\u3000\u3000\/mysqldata\/\u8868\u793a\u4fdd\u5b58\u5907\u4efd\u6587\u4ef6\u7684\u76ee\u5f55\uff0c\u8fd9\u4e2a\u6bcf\u4e2a\u4eba\u4e5f\u53ef\u4ee5\u6839\u636e\u81ea\u5df1\u7684\u8981\u6c42\u6765\u505a\u3002 <\/p>\n<p>\u3000\u30003\u3001\u4fee\u6539\u6587\u4ef6\u5c5e\u6027\uff0c\u4f7f\u5176\u53ef\u6267\u884c <\/p>\n<p>\u3000\u3000# chmod +x \/usr\/sbin\/bakmysql <\/p>\n<p>\u3000\u30004\u3001\u4fee\u6539\/etc\/crontab <\/p>\n<p>\u3000\u3000#vi \/etc\/crontab <\/p>\n<p>\u3000\u3000\u5728\u4e0b\u9762\u6dfb\u52a0 <\/p>\n<p>\u3000\u300001 3 * * * root \/usr\/sbin\/bakmysql <\/p>\n<p>\u3000\u3000\u8868\u793a\u6bcf\u59293\u70b9\u949f\u6267\u884c\u5907\u4efd <\/p>\n<p>\u3000\u30005\u3001\u91cd\u65b0\u542f\u52a8crond <\/p>\n<p>\u3000\u3000# \/etc\/rc.d\/init.d\/crond restart <\/p>\n<p>\u3000\u3000\u5b8c\u6210\u3002 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>mkdir \/home\/admin\/htdocs\/`date &#038;#&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-403","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts\/403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/comments?post=403"}],"version-history":[{"count":4,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts\/403\/revisions"}],"predecessor-version":[{"id":407,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts\/403\/revisions\/407"}],"wp:attachment":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/media?parent=403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/categories?post=403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/tags?post=403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}