{"id":661,"date":"2018-08-04T12:05:04","date_gmt":"2018-08-04T03:05:04","guid":{"rendered":"https:\/\/blog.mamimu.me\/fishblue\/?p=661"},"modified":"2018-08-04T12:05:04","modified_gmt":"2018-08-04T03:05:04","slug":"mysql%e3%81%ae%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/blog.mamimu.me\/fishblue\/?p=661","title":{"rendered":"MySQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5"},"content":{"rendered":"<p>\u4eca\u66f4\u3067\u3059\u304cMySQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n<p>mysql\u306f\u505c\u6b62\u3057\u307e\u305b\u3093\u3002mysqldump\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<br \/>\nmysqldump -u root -p -x &#8211;all-databases > \u30d5\u30a1\u30a4\u30eb\u540d<\/p>\n<p>\u79c1\u304cWordpress\u306eMySQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u3068\u304d\u306b\u4f7f\u7528\u3057\u3066\u3044\u308b\u30b3\u30de\u30f3\u30c9\u306f\u4ee5\u4e0b\u3067\u3059\u3002<br \/>\n# mysqldump -u root -p -x &#8211;all-databases > \/mysqldump\/`date +&#8221;%Y%m%d&#8221;`_blog.sql<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- rectungle --><br \/>\n<ins class=\"adsbygoogle\"\n     style=\"display:inline-block;width:300px;height:250px\"\n     data-ad-client=\"ca-pub-9128529039742412\"\n     data-ad-slot=\"9228809345\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u66f4\u3067\u3059\u304cMySQL\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5\u3067\u3059\u3002 mysql\u306f\u505c\u6b62\u3057\u307e\u305b\u3093\u3002mysqldump\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002 mysqldump -u root -p -x &#8211;all-databases > \u30d5\u30a1\u30a4\u30eb\u540d <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-661","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=\/wp\/v2\/posts\/661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=661"}],"version-history":[{"count":0,"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=\/wp\/v2\/posts\/661\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mamimu.me\/fishblue\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}