{"id":142,"date":"2009-12-17T17:57:50","date_gmt":"2009-12-17T09:57:50","guid":{"rendered":"http:\/\/blog.infinity.idv.tw\/index.php\/2009\/12\/17\/linux%e4%b8%8b%e8%ae%93%e7%b3%bb%e7%b5%b1%e8%87%aa%e5%8b%95%e5%88%aa%e9%99%a4mailwatch-30%e5%a4%a9%e5%be%8c%e7%9a%84log%e8%b3%87%e6%96%99\/"},"modified":"2009-12-17T17:57:50","modified_gmt":"2009-12-17T09:57:50","slug":"linux%e4%b8%8b%e8%ae%93%e7%b3%bb%e7%b5%b1%e8%87%aa%e5%8b%95%e5%88%aa%e9%99%a4mailwatch-30%e5%a4%a9%e5%be%8c%e7%9a%84log%e8%b3%87%e6%96%99","status":"publish","type":"post","link":"http:\/\/blog.infinity.idv.tw\/?p=142","title":{"rendered":"Linux\u4e0b\u8b93\u7cfb\u7d71\u81ea\u52d5\u522a\u9664MailWatch 30\u5929\u5f8c\u7684LOG\u8cc7\u6599"},"content":{"rendered":"<p>\u4fdd\u755930\u5929\u8cc7\u6599\u3002 <\/p>\n<p>\u5efa\u7acb\u9023\u7ddaMYSQL Shell <\/p>\n<p>vi \/usr\/local\/bin\/DelMailScannerLog.sh   <br \/>=====================================================    <br \/>#!\/bin\/sh    <br \/>mysql -uroot -p2duxaiux &lt; delmail.sql &gt;&gt; dellog.txt    <br \/>===================================================== <\/p>\n<p>\u5efa\u7acbsql\u6307\u4ee4\uff0c\u522a\u966430\u5929\u5f8c\u7684\u8cc7\u6599   <br \/>vi \/usr\/local\/bin\/delmail.sql    <br \/>=====================================================    <br \/>use mailscanner    <br \/>delete from maillog where date &lt; DATE_SUB(curdate(), INTERVAL 30 DAY);    <br \/>===================================================== <\/p>\n<p>\u6bcf\u65e5am12:30\u81ea\u52d5\u57f7\u884c   <br \/>=====================================================    <br \/>#\u7dad\u8b77MailWatchLog \u4fdd\u755930\u5929\u8cc7\u6599    <br \/>30 0 * * * root \/usr\/local\/bin\/DelMailScannerLog.sh    <br \/>=====================================================<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4fdd\u755930\u5929\u8cc7\u6599\u3002 <\/p>\n<p>\u5efa\u7acb\u9023\u7ddaMYSQL Shell <\/p>\n<p>vi \/usr\/local\/bin\/DelMailScannerLog.sh   =====================================================    #!\/bin\/sh    mysql -uroot -p2duxaiux &lt; delmail.sql &gt;&gt; dellog.txt    ===================================================== <\/p>\n<p>\u5efa\u7acbsql\u6307\u4ee4\uff0c\u522a\u966430\u5929\u5f8c\u7684\u8cc7\u6599   vi \/usr\/local\/bin\/delmail.sql    =====================================================    use mailscanner    delete from maillog where date &lt; DATE_SUB(curdate(), INTERVAL 30 DAY);   [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[158],"tags":[159,549,160],"_links":{"self":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/142"}],"collection":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=142"}],"version-history":[{"count":0,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/142\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}