{"id":1271,"date":"2009-07-28T21:39:41","date_gmt":"2009-07-28T12:39:41","guid":{"rendered":"http:\/\/gigasmegas.com\/?p=1271"},"modified":"2009-07-28T21:39:59","modified_gmt":"2009-07-28T12:39:59","slug":"mysql-tips-phpmyadmin%e3%81%a7%e3%82%a8%e3%82%af%e3%82%b9%e3%83%9d%e3%83%bc%e3%83%88%e3%81%97%e3%81%9f%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%e3%81%8c%e6%96%87%e5%ad%97%e5%8c%96","status":"publish","type":"post","link":"http:\/\/gigasmegas.com\/?p=1271","title":{"rendered":"MySQL Tips PHPMyAdmin\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u6587\u5b57\u5316\u3051"},"content":{"rendered":"<p><a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/rokuz.com\/?attachment_id=1272');\"  href=\"http:\/\/rokuz.com\/?attachment_id=1272\" rel=\"attachment wp-att-1272\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/rokuz.com\/wp-content\/uploads\/2009\/07\/snag-0192-400x261.png\" alt=\"mysqldump\u3067binary\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\" title=\"mysqldump\u3067binary\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\" width=\"400\" height=\"261\" class=\"alignnone size-medium wp-image-1272\" srcset=\"http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/07\/snag-0192-400x261.png 400w, http:\/\/gigasmegas.com\/wp-content\/uploads\/2009\/07\/snag-0192.png 750w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<address>photo by <a onclick=\"javascript:pageTracker._trackPageview('\/outgoing\/www.flickr.com\/photos\/byte\/');\"  href=\"http:\/\/www.flickr.com\/photos\/byte\/\">byte<\/a><\/address>\n<p>MySQL\u30c7\u30fc\u30bf\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3001\u7de8\u96c6\u306a\u3069\u3067\u7686\u3055\u3093\u3001\u304a\u4e16\u8a71\u306b\u306a\u3063\u3066\u3044\u308b\u3068\u601d\u308f\u308c\u308b\u3001\u4fbf\u5229\u306aPHPM\uff59Admin\u3002<\/p>\n<p>\u62e1\u5f35\u5b50SQL\u5f62\u5f0f\u306b\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u3068\u308a\u3001\u5225\u306eM\uff59SQL\u306b\u30c7\u30fc\u30bf\u79fb\u52d5\u3001\u30c7\u30fc\u30bf\u4fdd\u7ba1\u306a\u3069\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u51e6\u7406\u3067\u3001\u201d\u30fc\u201d\u3084\u3001\u201d\uff5e\u201d\u306a\u3069\u6587\u5b57\u5316\u3051\u3059\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u306f\u3001PHPM\uff59Admin\u304cmysqldump\u3057\u305f\u30c7\u30fc\u30bf\u3092UTF-8\u306b\u5909\u63db\u3059\u308b\u969b\u306b\u8d77\u3053\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n<p><!--more--><\/p>\n<p>PHPM\uff59Admin\u306f\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u306e\u969b\u3001UTF-8\u306b\u5909\u63db\u3059\u308b\u4ed5\u69d8\u3067\u5909\u66f4\u306f\u3067\u304d\u305d\u3046\u306b\u3042\u308a\u307e\u305b\u3093\u306e\u3067\u3001\u76f4\u63a5\u3001mysqldump\u30b3\u30de\u30f3\u30c9\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092binary\u5f62\u5f0f\u3067\u51fa\u529b\u3055\u305b\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>binary\u5f62\u5f0f\u306a\u306e\u3067\u3001\u4fdd\u5b58\u3055\u308c\u305f\u6587\u5b57\u30b3\u30fc\u30c9\u306e\u307e\u307e\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\nmysqldump -u root -p --compact --default-character-set=binary \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d &gt; \u51fa\u529b\u30d5\u30a1\u30a4\u30eb\u540d\r\n<\/pre>\n<p>\u3053\u308c\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u304c\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>photo by byte MySQL\u30c7\u30fc\u30bf\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3001\u7de8\u96c6\u306a\u3069\u3067\u7686\u3055\u3093\u3001\u304a\u4e16\u8a71\u306b\u306a\u3063\u3066\u3044\u308b\u3068\u601d\u308f\u308c\u308b\u3001\u4fbf\u5229\u306aPHPM\uff59Admin\u3002 \u62e1\u5f35\u5b50SQL\u5f62\u5f0f\u306b\u3066\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u3068\u308a\u3001\u5225\u306eM\uff59SQL\u306b [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[341,25,32],"tags":[392,394,254,386,393],"class_list":["post-1271","post","type-post","status-publish","format-standard","hentry","category-web-computer","category-computer","category-database","tag-mysql","tag-phpmyadmin","tag-tips","tag-xoops","tag-393"],"_links":{"self":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1271"}],"version-history":[{"count":4,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1271\/revisions"}],"predecessor-version":[{"id":1276,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=\/wp\/v2\/posts\/1271\/revisions\/1276"}],"wp:attachment":[{"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1271"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gigasmegas.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}