{"id":523,"date":"2023-09-25T07:07:49","date_gmt":"2023-09-24T23:07:49","guid":{"rendered":"https:\/\/www.dabaobao.net\/index.php\/2023\/09\/25\/e09bb41b0b\/"},"modified":"2023-09-25T15:07:55","modified_gmt":"2023-09-25T07:07:55","slug":"e09bb41b0b","status":"publish","type":"post","link":"https:\/\/cnaaa17.com\/index.php\/2023\/09\/25\/e09bb41b0b\/","title":{"rendered":"LNMP \u6570\u636e\u5e93\u5907\u4efd\u4fee\u6539\u4e3a\u538b\u7f29\u5907\u4efd"},"content":{"rendered":"

LNMP \u7684\u7f51\u7ad9\u5907\u4efd\u662f\u538b\u7f29\u683c\u5f0f\uff0c\u4f46\u662f\u6570\u636e\u5e93\u4e0d\u662f\u538b\u7f29\u683c\u5f0f\u3002\u4eca\u5929\u8fd9\u7bc7\u6587\u7ae0\u662f\u6559\u5927\u5bb6\u5982\u4f55\u8ba9\u6570\u636e\u5e93\u5907\u4efd\u4e3a\u538b\u7f29\u683c\u5f0f\u3002\u6b64\u65b9\u6cd5\u6765\u6e90\u4e8e LNMP \u5b98\u65b9\u8bba\u575b\u3002\u6709\u9700\u8981\u7684\u7ae5\u978b\u53ef\u4ee5\u7167\u7740\u4fee\u6539\u5c31\u53ef\u4ee5\u4e86\u3002\u542f\u7528\u4e86\u538b\u7f29\u540e\uff0c\u5907\u4efd\u7684\u6570\u636e\u5e93\u786e\u5b9e\u53d8\u5c0f\u4e86\u5f88\u591a\u3002\u5982\u679c\u4f60\u7684\u6570\u636e\u5e93\u4e0d\u5927\u4e5f\u53ef\u4ee5\u4e0d\u7528\u8bbe\u7f6e\u538b\u7f29\u3002<\/p>\n

0x01 \u67e5\u627e\u6587\u4ef6<\/h2>\n

\u8fdb\u5165\u5230 lnmptools \u76ee\u5f55\uff0c\u627e\u5230 backup.sh \u6587\u4ef6\u3002<\/p>\n

<\/figure>\n

0x02 \u7f16\u8f91\u6587\u4ef6<\/h2>\n

\u4f7f\u7528 vim \u7f16\u8f91 bakckup.sh \u6587\u4ef6\u3002\u5177\u4f53\u4fee\u6539\u7684\u4f4d\u7f6e\u53c2\u7167\u56fe\u7247\u3002<\/p>\n

\u67e5\u627e\uff1a<\/p>\n

  1. TodayDBBackup<\/span>=<\/span>db<\/span>-*-<\/span>$<\/span>(<\/span>date <\/span>+<\/span>\"%Y%m%d\"<\/span>).<\/span>sql<\/span><\/code><\/p><\/li>
  2. OldDBBackup<\/span>=<\/span>db<\/span>-*-<\/span>$<\/span>(<\/span>date <\/span>-<\/span>d <\/span>-<\/span>3day<\/span> <\/span>+<\/span>\"%Y%m%d\"<\/span>).<\/span>sql<\/span><\/code><\/p><\/li><\/ol><\/pre>\n
    \u4fee\u6539\u4e3a\uff1a<\/p>\n
    1. TodayDBBackup<\/span>=<\/span>db<\/span>-*-<\/span>$<\/span>(<\/span>date <\/span>+<\/span>\"%Y%m%d\"<\/span>).<\/span>sql<\/span>.<\/span>gz<\/span><\/code><\/p><\/li>
    2. OldDBBackup<\/span>=<\/span>db<\/span>-*-<\/span>$<\/span>(<\/span>date <\/span>-<\/span>d <\/span>-<\/span>3day<\/span> <\/span>+<\/span>\"%Y%m%d\"<\/span>).<\/span>sql<\/span>.<\/span>gz<\/span><\/code><\/p><\/li><\/ol><\/pre>\n
      \u67e5\u627e\uff1a<\/p>\n
      1. $<\/span>{<\/span>MySQL_Dump<\/span>}<\/span> <\/span>-<\/span>u$MYSQL_UserName <\/span>-<\/span>p$MYSQL_PassWord $1 <\/span>><\/span> $<\/span>{<\/span>Backup_Home<\/span>}<\/span>db<\/span>-<\/span>$1<\/span>-<\/span>$<\/span>(<\/span>date <\/span>+<\/span>\"%Y%m%d\"<\/span>).<\/span>sql<\/span><\/code><\/p><\/li><\/ol><\/pre>\n
        \u4fee\u6539\u4e3a\uff1a<\/p>\n
        1. $<\/span>{<\/span>MySQL_Dump<\/span>}<\/span> <\/span>-<\/span>u$MYSQL_UserName <\/span>-<\/span>p$MYSQL_PassWord $1 <\/span>|<\/span> gzip <\/span>><\/span> $<\/span>{<\/span>Backup_Home<\/span>}<\/span>db<\/span>-<\/span>$1<\/span>-<\/span>$<\/span>(<\/span>date <\/span>+<\/span>\"%Y%m%d\"<\/span>).<\/span>sql<\/span>.<\/span>gz<\/span><\/code><\/p><\/li><\/ol><\/pre>\n
          <\/figure>\n
          0x03 \u6587\u4ef6\u5bf9\u6bd4<\/h2>\n
          \u6ca1\u6709\u538b\u7f29\u7684\u6570\u636e\u5e93\u5907\u4efd\u6587\u4ef6\u5927\u5c0f\u4e3a\uff1a45.9M\uff0c\u538b\u7f29\u7684\u6570\u636e\u5e93\u5907\u4efd\u6587\u4ef6\u4e3a\uff1a9M \u6548\u679c\u8fd8\u662f\u5f88\u660e\u663e\u7684\u3002<\/p>\n
          <\/figure>\n

          <\/p>\n
          <\/mp-style-type><\/p>\n","protected":false},"excerpt":{"rendered":"
          LNMP \u7684\u7f51\u7ad9\u5907\u4efd\u662f\u538b\u7f29\u683c\u5f0f\uff0c\u4f46\u662f\u6570\u636e\u5e93\u4e0d\u662f\u538b\u7f29 …<\/p>\n","protected":false},"author":1,"featured_media":524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-523","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/posts\/523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/comments?post=523"}],"version-history":[{"count":1,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/posts\/523\/revisions"}],"predecessor-version":[{"id":528,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/posts\/523\/revisions\/528"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/media\/524"}],"wp:attachment":[{"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/media?parent=523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/categories?post=523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cnaaa17.com\/index.php\/wp-json\/wp\/v2\/tags?post=523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}