{"id":613,"date":"2024-04-15T10:36:12","date_gmt":"2024-04-15T01:36:12","guid":{"rendered":"http:\/\/inwelly.com\/?p=613"},"modified":"2024-04-15T10:36:12","modified_gmt":"2024-04-15T01:36:12","slug":"mysql-%eb%b0%b1%ec%97%85-%eb%b3%b5%ea%b5%ac","status":"publish","type":"post","link":"https:\/\/inwelly.com\/?p=613","title":{"rendered":"MYSQL \ubc31\uc5c5 , \ubcf5\uad6c"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>- character check\nmysql> show variables like \"c%\"\n\n- backup\n\n#> usr\/local\/mysql\/bin\/mysqldump -uroot -pPassword &#91;\ubc31\uc5c5\uc635\uc158] &#91;\ud658\uacbd\uc635\uc158] > Backup.sql\n\n&#91;\ubc31\uc5c5\uc635\uc158]\n--all-databases # mysql DB \uc804\uccb4\ub97c \ubc31\uc5c5\ub2e4\ub294\uac83\uc744 \uc758\ubbf8\ud55c\ub2e4.\n--databases DB1 DB2 DB3 # mysql \uc5d0\uc11c \ud2b9\uc815 DB\ub9cc \ubc31\uc5c5\ubc1b\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4.\nDB1 # DB1 \uc774\ub77c\ub294 DB \ub9cc \ubc31\uc5c5\ubc1b\uc744\ub54c \uc0ac\uc6a9\ud55c\ub2e4.\nDB1 table1 # DB1 \uc774\ub77c\ub294 DB\uc758 table1 \uc774\ub77c\ub294 \ud14c\uc774\ube14\ub9cc \ubc31\uc5c5\ubc1b\uc744\ub54c \uc0ac\uc6a9\ud55c\ub2e4.\n\n&#91;\ud658\uacbd\uc635\uc158] : \ubc31\uc5c5\uc2dc\uc5d0 \uc5b4\ub5a4\ud658\uacbd\uc73c\ub85c \ubc31\uc5c5\uc744 \ud560\uac83\uc778\uac00\uc5d0 \ub300\ud55c \uc635\uc158\uc774\ub2e4\n--default-character-set=utf8 # \uc9c0\uc815\ub41c \uce90\ub9ad\ud130\uc14b\uc744 \uae30\ubcf8\uc73c\ub85c\ud568\n--set-charset # \uae30\ubcf8\uc9c0\uc815\ub41c \uce90\ub9ad\ud130\uc14b(default-character-set)\uc744 SET NAMES default-character-set\ub85c \uc124\uc815\n--opt # \uba54\ubaa8\ub9ac\uc5d0 \ub85c\ub4dc\ud558\uc9c0 \uc54a\uace0 \ubc14\ub85c \ud654\uc77c\ub85c \ub364\ud504\n--create-options # create\ubb38 \ubc31\uc5c5\uc2dc\uc5d0 \ud14c\uc774\ube14 \uc124\uc815\uc744 \ud3ec\ud568\ud568.\n--compatible=DB # \ubc31\uc5c5sql\uc774 \ud2b9\uc815 db\uc5d0 \ud638\ud658\ub418\ub3c4\ub85d \ud568 \uc608) mysql40, mysql41, oracle, mssql\n--extended-insert=FALSE # insert \ubb38\uc744 \ud55c\uc904\uc529 \ub9cc\ub4e0\ub2e4\n--result-file=file # \uc9c0\uc815\ub41c file \ub85c \ubc14\ub85c \ub123\uc74c.. \"> \/BackUp\/Mysql\/Backup.sql\"  \uacfc \uac19\uc740 \uc758\ubbf8\n--triggers # \ud2b8\ub9ac\uac70 \ub364\ud504\n--no-create-db # DB \uc0dd\uc131\uc815\ubcf4\ub97c \ube8c\n--no-create-info # \ud14c\uc774\ube14 \uc0dd\uc131\uc815\ubcf4\ub97c \ube8c\n--no-data # \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ube8c\n\n- Recover\n\n\/usr\/local\/mysql\/bin\/mysql -uroot -pPassword &#91;\ud658\uacbd\uc635\uc158] &lt; Backup.sql\n\uc704\uc758 \ubc29\ubc95\uc740 \uc804\uccb4\ubcf5\uad6c\uc774\uba70 \ub2e8\uc704 DB\uac00 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294\uc0c1\ud0dc\uc5d0\uc11c db\ubcc4 \ubc31\uc5c5\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \ud55c\ub2e4.\n\/usr\/local\/mysql\/bin\/mysql -uroot -pPassword &#91;\ud658\uacbd\uc635\uc158] DB\uba85&lt; Backup.sql\n\n\nmysql> flush privileges ; ( \ubcf5\uc6d0\ub41c\uac83 DB \uc801\uc6a9 )\n\n\n- php db connect coding \ucc38\uc870  ( euckr  \uacbd\uc6b0 )\n\n&lt;?\n$dbconn = mysql_connect($dbcon_su,$dbcon_id,$dbcon_pw) || die(\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud558\uc600\uc2b5\ub2c8\ub2e4.\");\n$status = mysql_select_db($dbcon_db) or die(\"Could not select database\");\nmysql_query(\"SET NAMES euckr\");\n?><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\ubc31\uc5c5 - \ud55c\uae00 \uae68\uc9d0 \uc635\uc158\nmysql -uroot -p --default-character-set=euckr DB\uba85 &lt; .\/\ubc31\uc5c5\ud30c\uc77c.sql<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[103],"tags":[],"class_list":["post-613","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=613"}],"version-history":[{"count":1,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/613\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/inwelly.com\/index.php?rest_route=\/wp\/v2\/posts\/613\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inwelly.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}