{"id":1465,"date":"2026-05-13T23:16:14","date_gmt":"2026-05-13T14:16:14","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1465"},"modified":"2026-05-13T23:16:44","modified_gmt":"2026-05-13T14:16:44","slug":"http-wiki-igoni-kr-books-4-dbms-page-mysql-anb","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1465","title":{"rendered":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\ubaa9 \ucc28<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/www.igoni.kr\/?p=1465\/#%EB%B3%B5%EC%9B%90_%EC%8B%9C%EB%82%98%EB%A6%AC%EC%98%A4\" >\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624<\/a><\/li><\/ul><\/nav><\/div>\n<h3 id=\"bkmrk-%EB%B3%B5%EC%9B%90-%EC%8B%9C%EB%82%98%EB%A6%AC%EC%98%A4\" class=\"wikigeneratedid\"><span class=\"ez-toc-section\" id=\"%EB%B3%B5%EC%9B%90_%EC%8B%9C%EB%82%98%EB%A6%AC%EC%98%A4\"><\/span>\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669.\nSQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4.<\/p>\n<table style=\"border-collapse: collapse;width: 100%\" border=\"1\"><colgroup> <col style=\"width: 99.881%\"><\/colgroup>\n<tbody>\n<tr>\n<td><figure id=\"attachment_mmd_1467\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"900\" height=\"672\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/cbfc6e3c-7eae-4b05-a352-64c4ab594340.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" align=\"none\" \/><\/figure><\/td>\n<\/tr>\n<tr>\n<td class=\"align-right\">perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol id=\"bkmrk-sql%ED%98%95%ED%83%9C%EB%A1%9C-%EB%B0%B1%EC%97%85%EB%90%9C-%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC-%EC%9E%84%EC%8B%9C-d\">\n\n<li>SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0\n<pre><code class=\"language-Python\">$&gt; mysql -u root -p test &lt; backup.sql\nEnter password:<\/code><\/pre>\n<\/li>\n    <li class=\"null\">\ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30\n<pre><code class=\"language-Python\">$&gt; mysqldump -u root -p test member --where=&quot;id=&#039;test&#039;&quot; --skip-add-drop-table &gt; result.sql<\/code><\/pre>\n\u00a0\n\n<ul>\n    <li class=\"null\">skip-add-drop-table \uc635\uc158\uc744 \ucd94\uac00\ud574\uc8fc\uba74, \uae30\uc874 \ud14c\uc774\ube14\uc774 \uc788\uc744\ub54c, drop\ub418\ub294 \uac83\uc744 \ubc29\uc9c0<\/li>\n<\/ul>\n<\/li>\n    <li class=\"null\">\ucd94\ucd9c\ub41c sql \ud30c\uc77c\uc744 \uc0ac\uc6a9\uc911\uc778 DB\uc5d0 \ubcf5\uc6d0\n<pre><code class=\"language-Python\">$&gt; mysql -u root -p web &lt; result\nEnter password:<\/code><\/pre>\n\u00a0<\/li>\n<\/ol>\n<div id=\"bkmrk-\">\n<div class=\"box\">\n<div class=\"code\">\n<div class=\"linenoswrapper\">\n<div><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00&hellip;<\/p>","protected":false},"author":1,"featured_media":1467,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[391,383,413],"class_list":["post-1465","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlmariadb","tag-backup","tag-mysql","tag-restore"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $&gt; mysql -u root -p test &lt; backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $&gt; mysqldump -u\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"artop0420\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.igoni.kr\/?p=1465\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ko_KR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta property=\"og:description\" content=\"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $&gt; mysql -u root -p test &lt; backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $&gt; mysqldump -u\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.igoni.kr\/?p=1465\" \/>\n\t\t<meta property=\"og:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-05-13T14:16:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-05-13T14:16:44+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $&gt; mysql -u root -p test &lt; backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $&gt; mysqldump -u\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#blogposting\",\"name\":\"http:\\\/\\\/wiki.igoni.kr\\\/books\\\/4-dbms\\\/page\\\/mysql-AnB - \\uc774\\uace4\\uc544\\uc774\",\"headline\":\"http:\\\/\\\/wiki.igoni.kr\\\/books\\\/4-dbms\\\/page\\\/mysql-AnB\",\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/cbfc6e3c-7eae-4b05-a352-64c4ab594340.png\",\"width\":900,\"height\":672},\"datePublished\":\"2026-05-13T23:16:14+09:00\",\"dateModified\":\"2026-05-13T23:16:44+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#webpage\"},\"articleSection\":\"Mysql&amp;MariaDB, backup, mysql, restore\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.igoni.kr\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"position\":2,\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"position\":3,\"name\":\"Mysql&amp;MariaDB\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#listItem\",\"name\":\"http:\\\/\\\/wiki.igoni.kr\\\/books\\\/4-dbms\\\/page\\\/mysql-AnB\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#listItem\",\"position\":4,\"name\":\"http:\\\/\\\/wiki.igoni.kr\\\/books\\\/4-dbms\\\/page\\\/mysql-AnB\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#webpage\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465\",\"name\":\"http:\\\/\\\/wiki.igoni.kr\\\/books\\\/4-dbms\\\/page\\\/mysql-AnB - \\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\ubcf5\\uc6d0 \\uc2dc\\ub098\\ub9ac\\uc624 \\uc548\\ub155\\ud558\\uc138\\uc694, \\uace0\\ub2c8 \\uc785\\ub2c8\\ub2e4. \\ud604\\uc7ac \\uc0ac\\uc6a9\\uc911\\uc778 db\\uba85\\uc774 web\\uc774\\uace0, \\ud14c\\uc774\\ube14 \\uba85\\uc774 member\\uc758 \\ud14c\\uc774\\ube14\\uc758 \\ub370\\uc774\\ud130 \\uc911\\uc5d0\\uc11c id\\uac00 test\\uc778 \\ub370\\uc774\\ud130\\ub97c \\uc0ad\\uc81c\\ub41c \\uc0c1\\ud669. SQL \\ud615\\ud0dc\\ub85c \\ubc31\\uc5c5\\ub41c \\ub370\\uc774\\ud130\\uc5d0\\uc11c \\ubcf5\\uc6d0\\ud558\\ub294 \\uacfc\\uc815\\uc744 \\uc801\\uc5b4\\ubcf4\\ub824\\uace0 \\ud569\\ub2c8\\ub2e4. perplexity\\uc5d0\\uc11c \\uc0dd\\uc131\\ud55c AI\\uc774\\ubbf8\\uc9c0 SQL\\ud615\\ud0dc\\ub85c \\ubc31\\uc5c5\\ub41c \\ub370\\uc774\\ud130\\ub97c \\uc784\\uc2dc DB\\uc5d0 \\ubcf5\\uc6d0 $> mysql -u root -p test < backup.sql Enter password: \\ubcf5\\uc6d0\\ub41c \\uc784\\uc2dcDB\\uc5d0\\uc11c \\ucd94\\ucd9c\\ud574\\uc57c\\ud560 \\ub370\\uc774\\ud130 \\uc870\\uac74\\ub2ec\\uae30 $> mysqldump -u\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/cbfc6e3c-7eae-4b05-a352-64c4ab594340.png\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465\\\/#mainImage\",\"width\":900,\"height\":672},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1465#mainImage\"},\"datePublished\":\"2026-05-13T23:16:14+09:00\",\"dateModified\":\"2026-05-13T23:16:44+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/\",\"name\":\"\\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\uc798\\ub098\\uac00\\ub294 \\uc804\\uc0b0\\uc7c1\\uc774\\uc758 \\ube14\\ub85c\\uadf8\",\"inLanguage\":\"ko-KR\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774","description":"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $> mysql -u root -p test < backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $> mysqldump -u","canonical_url":"http:\/\/www.igoni.kr\/?p=1465","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/www.igoni.kr\/?p=1465#blogposting","name":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774","headline":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB","author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"publisher":{"@id":"http:\/\/www.igoni.kr\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/cbfc6e3c-7eae-4b05-a352-64c4ab594340.png","width":900,"height":672},"datePublished":"2026-05-13T23:16:14+09:00","dateModified":"2026-05-13T23:16:44+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1465#webpage"},"isPartOf":{"@id":"http:\/\/www.igoni.kr\/?p=1465#webpage"},"articleSection":"Mysql&amp;MariaDB, backup, mysql, restore"},{"@type":"BreadcrumbList","@id":"http:\/\/www.igoni.kr\/?p=1465#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","position":1,"name":"Home","item":"http:\/\/www.igoni.kr","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","position":2,"name":"4. DBMS \uc815\ubcf4 \uae30\ub85d","item":"http:\/\/www.igoni.kr\/?cat=379","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","position":3,"name":"Mysql&amp;MariaDB","item":"http:\/\/www.igoni.kr\/?cat=381","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1465#listItem","name":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1465#listItem","position":4,"name":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB","previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"}}]},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/#person","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1465#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/?author=1#author","url":"http:\/\/www.igoni.kr\/?author=1","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1465#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"WebPage","@id":"http:\/\/www.igoni.kr\/?p=1465#webpage","url":"http:\/\/www.igoni.kr\/?p=1465","name":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774","description":"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $> mysql -u root -p test < backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $> mysqldump -u","inLanguage":"ko-KR","isPartOf":{"@id":"http:\/\/www.igoni.kr\/#website"},"breadcrumb":{"@id":"http:\/\/www.igoni.kr\/?p=1465#breadcrumblist"},"author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"creator":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/cbfc6e3c-7eae-4b05-a352-64c4ab594340.png","@id":"http:\/\/www.igoni.kr\/?p=1465\/#mainImage","width":900,"height":672},"primaryImageOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1465#mainImage"},"datePublished":"2026-05-13T23:16:14+09:00","dateModified":"2026-05-13T23:16:44+09:00"},{"@type":"WebSite","@id":"http:\/\/www.igoni.kr\/#website","url":"http:\/\/www.igoni.kr\/","name":"\uc774\uace4\uc544\uc774","description":"\uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","inLanguage":"ko-KR","publisher":{"@id":"http:\/\/www.igoni.kr\/#person"}}]},"og:locale":"ko_KR","og:site_name":"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","og:type":"article","og:title":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774","og:description":"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $&gt; mysql -u root -p test &lt; backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $&gt; mysqldump -u","og:url":"http:\/\/www.igoni.kr\/?p=1465","og:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg","article:published_time":"2026-05-13T14:16:14+00:00","article:modified_time":"2026-05-13T14:16:44+00:00","twitter:card":"summary_large_image","twitter:title":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB - \uc774\uace4\uc544\uc774","twitter:description":"\ubcf5\uc6d0 \uc2dc\ub098\ub9ac\uc624 \uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. \ud604\uc7ac \uc0ac\uc6a9\uc911\uc778 db\uba85\uc774 web\uc774\uace0, \ud14c\uc774\ube14 \uba85\uc774 member\uc758 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \uc911\uc5d0\uc11c id\uac00 test\uc778 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ub41c \uc0c1\ud669. SQL \ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uc5d0\uc11c \ubcf5\uc6d0\ud558\ub294 \uacfc\uc815\uc744 \uc801\uc5b4\ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 SQL\ud615\ud0dc\ub85c \ubc31\uc5c5\ub41c \ub370\uc774\ud130\ub97c \uc784\uc2dc DB\uc5d0 \ubcf5\uc6d0 $&gt; mysql -u root -p test &lt; backup.sql Enter password: \ubcf5\uc6d0\ub41c \uc784\uc2dcDB\uc5d0\uc11c \ucd94\ucd9c\ud574\uc57c\ud560 \ub370\uc774\ud130 \uc870\uac74\ub2ec\uae30 $&gt; mysqldump -u","twitter:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg"},"aioseo_meta_data":{"post_id":"1465","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-05-13 14:16:14","updated":"2026-08-07 15:16:39","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=379\" title=\"4. DBMS \uc815\ubcf4 \uae30\ub85d\">4. DBMS \uc815\ubcf4 \uae30\ub85d<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=381\" title=\"Mysql&amp;MariaDB\">Mysql&amp;MariaDB<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\thttp:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.igoni.kr"},{"label":"4. DBMS \uc815\ubcf4 \uae30\ub85d","link":"http:\/\/www.igoni.kr\/?cat=379"},{"label":"Mysql&amp;MariaDB","link":"http:\/\/www.igoni.kr\/?cat=381"},{"label":"http:\/\/wiki.igoni.kr\/books\/4-dbms\/page\/mysql-AnB","link":"http:\/\/www.igoni.kr\/?p=1465"}],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1465"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1465\/revisions"}],"predecessor-version":[{"id":1469,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1465\/revisions\/1469"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1467"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1465"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}