{"id":1335,"date":"2013-02-18T17:31:57","date_gmt":"2013-02-18T08:31:57","guid":{"rendered":"http:\/\/blog.4star.link\/?p=1335"},"modified":"2013-02-18T17:31:57","modified_gmt":"2013-02-18T08:31:57","slug":"mysql%ef%bc%9a%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e5%8d%98%e4%bd%8d%e3%81%ae%e3%83%80%e3%83%b3%e3%83%97%e3%83%aa%e3%82%b9%e3%83%88%e3%82%a2%e3%81%ae%e3%83%a1%e3%83%a2","status":"publish","type":"post","link":"https:\/\/blog.4star.link\/?p=1335","title":{"rendered":"MySQL\uff1a\u30c6\u30fc\u30d6\u30eb\u5358\u4f4d\u306e\u30c0\u30f3\u30d7&#038;\u30ea\u30b9\u30c8\u30a2\u306e\u30e1\u30e2"},"content":{"rendered":"<p><span style=\"color: #ff0000;\">\u203b\u30dd\u30a4\u30f3\u30c8 &#8211;default-character-set=binary\u3000\u6587\u5b57\u5316\u3051\u5bfe\u7b56<\/span><\/p>\n<pre><strong>\u30c6\u30fc\u30d6\u30eb\u6307\u5b9a\u30c0\u30f3\u30d7\n<\/strong>mysqldump -u testuser testdb -p --default-character-set=binary --tables testtable &gt; [\u51fa\u529b\u5148\u30d5\u30a1\u30a4\u30eb\u540d].sql<\/pre>\n<pre><strong>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3057\u3066\u3001\u4e0a\u8a18\u306e\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u306e\u30ea\u30b9\u30c8\u30a2<\/strong>\n<span style=\"font-family: 'Courier 10 Pitch', Courier, monospace; font-size: 13px; font-style: normal; line-height: 1.5;\">mysql -u testuser testdb -p --default-character-set=binary &lt; [\u51fa\u529b\u5148\u30d5\u30a1\u30a4\u30eb\u540d].sql\n<\/span><\/pre>\n<pre><strong>\u6307\u5b9a\u30c6\u30fc\u30d6\u30eb\u4ee5\u5916\u3092\u30c0\u30f3\u30d7\u3059\u308b\u5834\u5408<\/strong>\nmysqldump -u testuser -p testdb --default-character-set=binary --ignore-table=testdb.testtable1 --ignore-table=testdb.testtable2 &gt; [\u51fa\u529b\u5148\u30d5\u30a1\u30a4\u30eb\u540d].sql<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u203b\u30dd\u30a4\u30f3\u30c8 &#8211;default-character-set=binary\u3000\u6587\u5b57\u5316\u3051\u5bfe\u7b56 \u30c6\u30fc\u30d6\u30eb\u6307\u5b9a\u30c0\u30f3\u30d7 mysqldump -u testuser testdb -p &#8211;default-character &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/blog.4star.link\/?p=1335\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;MySQL\uff1a\u30c6\u30fc\u30d6\u30eb\u5358\u4f4d\u306e\u30c0\u30f3\u30d7&#038;\u30ea\u30b9\u30c8\u30a2\u306e\u30e1\u30e2&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/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":[199,200,31,201,202,203,204],"class_list":["post-1335","post","type-post","status-publish","format-standard","hentry","category-1","tag-charset","tag-dump","tag-mysql","tag-mysqldump","tag-202","tag-203","tag-204"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts\/1335"}],"collection":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1335"}],"version-history":[{"count":0,"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts\/1335\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}