{"id":104,"date":"2017-10-30T15:25:15","date_gmt":"2017-10-30T07:25:15","guid":{"rendered":"https:\/\/damogame.cn\/?p=104"},"modified":"2017-10-30T15:25:15","modified_gmt":"2017-10-30T07:25:15","slug":"linux%e4%b8%8b%e5%a6%82%e4%bd%95%e5%ae%9e%e7%8e%b0mysql%e6%95%b0%e6%8d%ae%e5%ba%93%e6%af%8f%e5%a4%a9%e8%87%aa%e5%8a%a8%e5%a4%87%e4%bb%bd%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/104","title":{"rendered":"linux\u4e0b\u5982\u4f55\u5b9e\u73b0mysql\u6570\u636e\u5e93\u6bcf\u5929\u81ea\u52a8\u5907\u4efd\u5b9a\u65f6\u5907\u4efd"},"content":{"rendered":"<p>\u8fd9\u91cc\u4e3b\u8981\u4ee5\u672c\u5730\u78c1\u76d8\u4e3a\u5b58\u50a8\u4ecb\u8d28\u8bb2\u4e00\u4e0b\u8ba1\u5212\u4efb\u52a1\u7684\u6dfb\u52a0\u4f7f\u7528\uff0c\u57fa\u672c\u7684<b>\u5907\u4efd<\/b>\u811a\u672c\uff0c\u5176\u5b83\u5b58\u50a8\u4ecb\u8d28\u53ea\u662f\u4ecb\u8d28\u7684\u8bbf\u95ee\u65b9\u5f0f\u53ef\u80fd\u4e0d\u5927\u4e00\u6837\u3002<\/p>\n<h1 id=\"1\u67e5\u770b\u78c1\u76d8\u7a7a\u95f4\u60c5\u51b5\">1\u3001\u67e5\u770b\u78c1\u76d8\u7a7a\u95f4\u60c5\u51b5\uff1a<\/h1>\n<p>\u65e2\u7136\u662f\u5b9a\u65f6<b>\u5907\u4efd<\/b>\uff0c\u5c31\u8981\u9009\u62e9\u4e00\u4e2a\u7a7a\u95f4\u5145\u8db3\u7684\u78c1\u76d8\u7a7a\u95f4\uff0c\u907f\u514d\u51fa\u73b0\u56e0\u7a7a\u95f4\u4e0d\u8db3\u5bfc\u81f4<b>\u5907\u4efd<\/b>\u5931\u8d25\uff0c\u6570\u636e\u4e22\u5931\u7684\u6076\u679c\uff01<br \/>\n\u5b58\u50a8\u5230\u5f53\u524d\u78c1\u76d8\u8fd9\u662f\u6700\u7b80\u5355\uff0c\u5374\u662f\u6700\u4e0d\u63a8\u8350\u7684\uff1b\u670d\u52a1\u5668\u6709\u591a\u5757\u786c\u76d8\uff0c\u6700\u597d\u662f\u628a<b>\u5907\u4efd<\/b>\u5b58\u653e\u5230\u53e6\u4e00\u5757\u786c\u76d8\u4e0a\uff1b\u6709\u6761\u4ef6\u5c31\u9009\u62e9\u66f4\u597d\u66f4\u5b89\u5168\u7684\u5b58\u50a8\u4ecb\u8d28\uff1b<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs erlang-repl\"># <span class=\"hljs-function_or_atom\">df<\/span> -<span class=\"hljs-function_or_atom\">h<\/span>\r\n<span class=\"hljs-variable\">Filesystem<\/span>                    <span class=\"hljs-variable\">Size<\/span>  <span class=\"hljs-variable\">Used<\/span> <span class=\"hljs-variable\">Avail<\/span> <span class=\"hljs-variable\">Use<\/span><span class=\"hljs-comment\">% Mounted on<\/span>\r\n\/<span class=\"hljs-function_or_atom\">dev<\/span>\/<span class=\"hljs-function_or_atom\">mapper<\/span>\/<span class=\"hljs-variable\">VolGroup<\/span>-<span class=\"hljs-function_or_atom\">lv_root<\/span>   <span class=\"hljs-number\">50<\/span><span class=\"hljs-variable\">G<\/span>   <span class=\"hljs-number\">46<\/span><span class=\"hljs-variable\">G<\/span>  <span class=\"hljs-number\">1.6<\/span><span class=\"hljs-variable\">G<\/span>  <span class=\"hljs-number\">97<\/span><span class=\"hljs-comment\">% \/<\/span>\r\n<span class=\"hljs-function_or_atom\">tmpfs<\/span>                         <span class=\"hljs-number\">1.9<\/span><span class=\"hljs-variable\">G<\/span>   <span class=\"hljs-number\">92<\/span><span class=\"hljs-variable\">K<\/span>  <span class=\"hljs-number\">1.9<\/span><span class=\"hljs-variable\">G<\/span>   <span class=\"hljs-number\">1<\/span><span class=\"hljs-comment\">% \/dev\/shm<\/span>\r\n\/<span class=\"hljs-function_or_atom\">dev<\/span>\/<span class=\"hljs-function_or_atom\">sda1<\/span>                     <span class=\"hljs-number\">485<\/span><span class=\"hljs-variable\">M<\/span>   <span class=\"hljs-number\">39<\/span><span class=\"hljs-variable\">M<\/span>  <span class=\"hljs-number\">421<\/span><span class=\"hljs-variable\">M<\/span>   <span class=\"hljs-number\">9<\/span><span class=\"hljs-comment\">% \/boot<\/span>\r\n\/<span class=\"hljs-function_or_atom\">dev<\/span>\/<span class=\"hljs-function_or_atom\">mapper<\/span>\/<span class=\"hljs-variable\">VolGroup<\/span>-<span class=\"hljs-function_or_atom\">lv_home<\/span>  <span class=\"hljs-number\">534<\/span><span class=\"hljs-variable\">G<\/span>  <span class=\"hljs-number\">3.6<\/span><span class=\"hljs-variable\">G<\/span>  <span class=\"hljs-number\">503<\/span><span class=\"hljs-variable\">G<\/span>   <span class=\"hljs-number\">1<\/span><span class=\"hljs-comment\">% \/home<\/span><\/code><\/pre>\n<h1 id=\"2\u521b\u5efa\u5907\u4efd\u76ee\u5f55\">2\u3001\u521b\u5efa<b>\u5907\u4efd<\/b>\u76ee\u5f55\uff1a<\/h1>\n<p>\u4e0a\u9762\u6211\u4eec\u4f7f\u7528\u547d\u4ee4\u770b\u51fa\/home\u4e0b\u7a7a\u95f4\u6bd4\u8f83\u5145\u8db3\uff0c\u6240\u4ee5\u53ef\u4ee5\u8003\u8651\u5728\/home\u4fdd\u5b58<b>\u5907\u4efd<\/b>\u6587\u4ef6\uff1b<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs bash\"><span class=\"hljs-built_in\">cd<\/span> \/home\r\nmkdir backup\r\n<span class=\"hljs-built_in\">cd<\/span> backup<\/code><\/pre>\n<h1 id=\"3\u521b\u5efa\u5907\u4efdshell\u811a\u672c\">3\u3001\u521b\u5efa<b>\u5907\u4efd<\/b>Shell\u811a\u672c:<\/h1>\n<p>\u6ce8\u610f\u628a\u4ee5\u4e0b\u547d\u4ee4\u4e2d\u7684DatabaseName\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u540d\u79f0\uff1b<br \/>\n\u5f53\u7136\uff0c\u4f60\u4e5f\u53ef\u4ee5\u4f7f\u7528\u5176\u5b9e\u7684\u547d\u540d\u89c4\u5219\uff01<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs avrasm\">vi bkDatabaseName<span class=\"hljs-preprocessor\">.sh<\/span><\/code><\/pre>\n<p>\u8f93\u5165\/\u7c98\u8d34\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs bash\"><span class=\"hljs-shebang\">#!\/bin\/bash<\/span>\r\nmysqldump -uusername -ppassword DatabaseName &gt; \/home\/backup\/DatabaseName_$(date +%Y%m%d_%H%M%S).sql<\/code><\/pre>\n<p>\u5bf9<b>\u5907\u4efd<\/b>\u8fdb\u884c\u538b\u7f29\uff1a<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs bash\"><span class=\"hljs-shebang\">#!\/bin\/bash<\/span>\r\nmysqldump -uusername -ppassword DatabaseName | gzip &gt; \/home\/backup\/DatabaseName_$(date +%Y%m%d_%H%M%S).sql.gz<\/code><\/pre>\n<p><strong>\u6ce8\u610f\uff1a<\/strong><br \/>\n\u628a username \u66ff\u6362\u4e3a\u5b9e\u9645\u7684\u7528\u6237\u540d\uff1b<br \/>\n\u628a password \u66ff\u6362\u4e3a\u5b9e\u9645\u7684\u5bc6\u7801\uff1b<br \/>\n\u628a DatabaseName \u66ff\u6362\u4e3a\u5b9e\u9645\u7684\u6570\u636e\u5e93\u540d\uff1b<\/p>\n<h1 id=\"4\u6dfb\u52a0\u53ef\u6267\u884c\u6743\u9650\">4\u3001\u6dfb\u52a0\u53ef\u6267\u884c\u6743\u9650\uff1a<\/h1>\n<pre class=\"prettyprint\"><code class=\" hljs perl\"><span class=\"hljs-keyword\">chmod<\/span> u+<span class=\"hljs-keyword\">x<\/span> bkDatabaseName.sh<\/code><\/pre>\n<p>\u6dfb\u52a0\u53ef\u6267\u884c\u6743\u9650\u4e4b\u540e\u5148\u6267\u884c\u4e00\u4e0b\uff0c\u770b\u770b\u811a\u672c\u6709\u6ca1\u6709\u9519\u8bef\uff0c\u80fd\u4e0d\u80fd\u6b63\u5e38\u4f7f\u7528\uff1b<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs avrasm\">.\/bkDatabaseName<span class=\"hljs-preprocessor\">.sh<\/span><\/code><\/pre>\n<h1 id=\"5\u6dfb\u52a0\u8ba1\u5212\u4efb\u52a1\">5\u3001\u6dfb\u52a0\u8ba1\u5212\u4efb\u52a1<\/h1>\n<h2 id=\"\u68c0\u6d4b\u6216\u5b89\u88c5-crontab\">\u68c0\u6d4b\u6216\u5b89\u88c5 crontab<\/h2>\n<p>\u786e\u8ba4crontab\u662f\u5426\u5b89\u88c5\uff1a<br \/>\n\u6267\u884c crontab \u547d\u4ee4\u5982\u679c\u62a5 command not found\uff0c\u5c31\u8868\u660e\u6ca1\u6709\u5b89\u88c5<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs livecodeserver\"><span class=\"hljs-comment\"># crontab<\/span>\r\n-bash: crontab: <span class=\"hljs-command\"><span class=\"hljs-keyword\">command<\/span> <span class=\"hljs-title\">not<\/span> <span class=\"hljs-title\">found<\/span><\/span><\/code><\/pre>\n<p>\u5982\u65f6\u6ca1\u6709\u5b89\u88c5 crontab\uff0c\u9700\u8981\u5148\u5b89\u88c5\u5b83\uff0c\u5177\u4f53\u6b65\u9aa4\u8bf7\u53c2\u8003\uff1a<br \/>\n<a href=\"http:\/\/blog.csdn.net\/testcs_dn\/article\/details\/48780971\">CentOS\u4e0b\u4f7f\u7528yum\u547d\u4ee4\u5b89\u88c5\u8ba1\u5212\u4efb\u52a1\u7a0b\u5e8fcrontab<\/a><br \/>\n<a href=\"http:\/\/blog.csdn.net\/testcs_dn\/article\/details\/48781553\">\u4f7f\u7528rpm\u547d\u4ee4\u4eceCentOS\u7cfb\u7edf\u76d8\u5b89\u88c5\u8ba1\u5212\u4efb\u52a1\u7a0b\u5e8fcrontab<\/a><\/p>\n<h2 id=\"\u6dfb\u52a0\u8ba1\u5212\u4efb\u52a1\">\u6dfb\u52a0\u8ba1\u5212\u4efb\u52a1<\/h2>\n<p>\u6267\u884c\u547d\u4ee4\uff1a<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs bash\">crontab <span class=\"hljs-operator\">-e<\/span><\/code><\/pre>\n<p>\u8fd9\u65f6\u5c31\u50cf\u4f7f\u7528vi\u7f16\u8f91\u5668\u4e00\u6837\uff0c\u53ef\u4ee5\u5bf9\u8ba1\u5212\u4efb\u52a1\u8fdb\u884c\u7f16\u8f91\u3002<br \/>\n\u8f93\u5165\u4ee5\u4e0b\u5185\u5bb9\u5e76\u4fdd\u5b58\uff1a<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs ruby\">*<span class=\"hljs-regexp\">\/1 * * * * \/home<\/span><span class=\"hljs-regexp\">\/backup\/bk<\/span>DatabaseName.sh<\/code><\/pre>\n<p>\u5177\u4f53\u662f\u4ec0\u4e48\u610f\u601d\u5462\uff1f<br \/>\n\u610f\u601d\u662f\u6bcf\u4e00\u5206\u949f\u6267\u884c<a name=\"baidusnap2\"><\/a><b>\u4e00\u6b21<\/b>shell\u811a\u672c\u201c\/home\/backup\/bkDatabaseName.sh\u201d\u3002<\/p>\n<h1 id=\"6\u6d4b\u8bd5\u4efb\u52a1\u662f\u5426\u6267\u884c\">6\u3001\u6d4b\u8bd5\u4efb\u52a1\u662f\u5426\u6267\u884c<\/h1>\n<p>\u5f88\u7b80\u5355\uff0c\u6211\u4eec\u5c31\u6267\u884c\u51e0\u6b21\u201cls\u201d\u547d\u4ee4\uff0c\u770b\u770b\u4e00\u5206\u949f\u8fc7\u540e\u6587\u4ef6\u6709\u6ca1\u6709\u88ab\u521b\u5efa\u5c31\u53ef\u4ee5\u4e86\uff01<\/p>\n<p>\u5982\u679c\u4efb\u52a1\u6267\u884c\u5931\u8d25\u4e86\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u67e5\u770b\u4efb\u52a1\u65e5\u5fd7\uff1a<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs vala\"><span class=\"hljs-preprocessor\"># tail -f \/var\/log\/cron<\/span><\/code><\/pre>\n<p>\u8f93\u51fa\u7c7b\u4f3c\u5982\u4e0b\uff1a<\/p>\n<pre class=\"prettyprint\"><code class=\" hljs avrasm\">Sep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">14<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon run-parts(\/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)[<span class=\"hljs-number\">2503<\/span>]: starting <span class=\"hljs-number\">0<\/span>anacron\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">14<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon run-parts(\/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)[<span class=\"hljs-number\">2512<\/span>]: finished <span class=\"hljs-number\">0<\/span>anacron\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon CROND[<span class=\"hljs-number\">3092<\/span>]: (root) CMD (run-parts \/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon run-parts(\/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)[<span class=\"hljs-number\">3092<\/span>]: starting <span class=\"hljs-number\">0<\/span>anacron\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">02<\/span> bogon run-parts(\/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)[<span class=\"hljs-number\">3101<\/span>]: finished <span class=\"hljs-number\">0<\/span>anacron\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">50<\/span>:<span class=\"hljs-number\">44<\/span> bogon crontab[<span class=\"hljs-number\">3598<\/span>]: (root) BEGIN EDIT (root)\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">16<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon CROND[<span class=\"hljs-number\">3705<\/span>]: (root) CMD (run-parts \/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">16<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon run-parts(\/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)[<span class=\"hljs-number\">3705<\/span>]: starting <span class=\"hljs-number\">0<\/span>anacron\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">16<\/span>:<span class=\"hljs-number\">01<\/span>:<span class=\"hljs-number\">01<\/span> bogon run-parts(\/etc\/cron<span class=\"hljs-preprocessor\">.hourly<\/span>)[<span class=\"hljs-number\">3714<\/span>]: finished <span class=\"hljs-number\">0<\/span>anacron\r\nSep <span class=\"hljs-number\">30<\/span> <span class=\"hljs-number\">16<\/span>:<span class=\"hljs-number\">15<\/span>:<span class=\"hljs-number\">29<\/span> bogon crontab[<span class=\"hljs-number\">3598<\/span>]: (root) END EDIT (root)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u91cc\u4e3b\u8981\u4ee5\u672c\u5730\u78c1\u76d8\u4e3a\u5b58\u50a8\u4ecb\u8d28\u8bb2\u4e00\u4e0b\u8ba1\u5212\u4efb<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[117],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry","tag-01-linux"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}