{"id":463,"date":"2014-04-05T13:12:05","date_gmt":"2014-04-05T04:12:05","guid":{"rendered":"http:\/\/www.uturtle.com\/blog\/?p=463"},"modified":"2014-04-05T13:19:02","modified_gmt":"2014-04-05T04:19:02","slug":"mysql-%ec%97%ac%eb%9f%ac-sql%ed%8c%8c%ec%9d%bc%ec%9d%84-%ec%bd%98%ec%86%94%ec%97%90%ec%84%9c-%ed%95%9c-%eb%b2%88%ec%97%90-%ec%8b%a4%ed%96%89%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/www.jinukbaek.com\/blog\/ko\/archives\/463","title":{"rendered":"[mysql] \uc5ec\ub7ec sql\ud30c\uc77c\uc744 \ucf58\uc194\uc5d0\uc11c \ud55c \ubc88\uc5d0 \uc2e4\ud589\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"<pre class=\"lang:default decode:true\">$ cat *.sql | mysql -u &lt;mysql_id&gt; -p &lt;target_database&gt;<\/pre>\n<p>cat \uba85\ub839\uc73c\ub85c stdout\uc73c\ub85c \ubaa8\ub4e0 sql\uc744 \ucd9c\ub825\ud558\uace0 \uc774\ub97c \ud30c\uc774\ud504\ub85c \ub118\uaca8\uc11c \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\uc774\ub2e4. \ucc3e\uc544 \ubcf8 \ubc29\ubc95[1] \uc911\uc5d0\ub294 \uc774\uac83\uc774 \uc81c\uc77c \uc774\ud574\ud558\uae30 \uc27d\uace0 \uac04\ub2e8\ud55c\ub4ef \ud558\ub2e4. mysql\uc758 \ubc31\uc5c5\uc740 *.sql \ud30c\uc77c\ub85c \ub098\uc624\ub294\ub370 \uc774\ub97c \ud55c \ubc88\uc5d0 \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \ubc29\ubc95\uc73c\ub85c \uc4f8 \uc218 \uc788\uaca0\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h6>\ucc38\uace0\uc790\ub8cc<\/h6>\n<hr \/>\n<p>[1] http:\/\/stackoverflow.com\/questions\/2458571\/run-multiple-sql-files-in-mysql-batch<\/p>\n","protected":false},"excerpt":{"rendered":"<p>$ cat *.sql | mysql -u &lt;mysql_id&gt; -p &lt;target_database&gt; cat \uba85\ub839\uc73c\ub85c stdout\uc73c\ub85c \ubaa8\ub4e0 sql\uc744 \ucd9c\ub825\ud558\uace0 \uc774\ub97c \ud30c\uc774\ud504\ub85c \ub118\uaca8\uc11c<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[174],"tags":[192,193],"class_list":["post-463","post","type-post","status-publish","format-standard","hentry","category-computer-database","tag-mysql","tag-sql-"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8gT1J-7t","_links":{"self":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/comments?post=463"}],"version-history":[{"count":2,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/463\/revisions"}],"predecessor-version":[{"id":465,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/posts\/463\/revisions\/465"}],"wp:attachment":[{"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/media?parent=463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/categories?post=463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jinukbaek.com\/blog\/wp-json\/wp\/v2\/tags?post=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}