{"id":107,"date":"2016-10-26T12:42:47","date_gmt":"2016-10-26T03:42:47","guid":{"rendered":"http:\/\/jook.pe.kr\/?p=107"},"modified":"2016-10-26T12:42:47","modified_gmt":"2016-10-26T03:42:47","slug":"mysql-%eb%8b%a4%ec%9a%b4%ea%b7%b8%eb%a0%88%ec%9d%b4%eb%93%9c4-1-4-0","status":"publish","type":"post","link":"http:\/\/jook.pe.kr\/?p=107","title":{"rendered":"mysql \ub2e4\uc6b4\uadf8\ub808\uc774\ub4dc(4.1-&gt;4.0)"},"content":{"rendered":"<p>mysql 4.1\uc774\uc0c1 \ubc84\uc804\uc5d0\uc11c 4.0\uc774\ud558 \ubc84\uc804\uc73c\ub85c \ub2e4\uc6b4 \uadf8\ub808\uc774\ub4dc<\/p>\n<p>1. 4.1\uc5d0\uc11c \ub364\ud504 \ubc1b\uc744\ub54c &#8211;default-character-set=euckr \uc635\uc158\uc744 \uc8fc\uace0 \ub364\ud504 \ubc1b\ub294\ub2e4.<\/p>\n<p>mysqldump &#8211;default-character-set=euckr -u xxx -p xxx &gt; xxx.sql<\/p>\n<p>2. \ub364\ud504\ubc1b\uc740 xxx.sql \ud30c\uc77c\uc744 vi \ud3b8\uc9d1\uae30\ub85c \uc5f4\uace0 \ud3b8\uc9d1<\/p>\n<p>&#8221; DEFAULT CHARSET=euckr&#8221; \uc0ad\uc81c\u00a0\u00a0\u00a0\u00a0 :%s\/ DEFAULT CHARSET=euckr\/\/g<br \/>\n&#8221; collate euckr_bin&#8221; \uc0ad\uc81c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :%s\/ collate euckr_bin\/\/g<br \/>\neuckr -&gt; euc_kr\ub85c \ubcc0\uacbd\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0:%s\/euckr\/euc_kr\/g<\/p>\n<p>3. xxx.sql\uc744 4.0\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \ubcf5\uad6c<\/p>\n<p>mysql -u xxx -p xxx &lt; xxx.sql<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql 4.1\uc774\uc0c1 \ubc84\uc804\uc5d0\uc11c 4.0\uc774\ud558 \ubc84\uc804\uc73c\ub85c \ub2e4\uc6b4 \uadf8\ub808\uc774\ub4dc 1. 4.1\uc5d0\uc11c \ub364\ud504 \ubc1b\uc744\ub54c &#8211;default-character-set=euckr \uc635\uc158\uc744 \uc8fc\uace0 \ub364\ud504 \ubc1b\ub294\ub2e4. mysqldump &#8211;default-character-set=euckr -u xxx<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/107"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=107"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/107\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}