{"id":384,"date":"2018-08-31T14:41:51","date_gmt":"2018-08-31T05:41:51","guid":{"rendered":"http:\/\/dong1lkim.oboki.net\/?p=384"},"modified":"2019-09-01T22:21:05","modified_gmt":"2019-09-01T13:21:05","slug":"mysql-mysqldump","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/mysql\/mysql-mysqldump\/","title":{"rendered":"[MySQL] mysqldump"},"content":{"rendered":"<h1>mysqldump<\/h1>\n<p>mysqldump \ud504\ub85c\uc138\uc2a4\uac00 \uc2e4\ud589\ub41c \uc21c\uac04\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \ubc0f \ub370\uc774\ud130\ub97c SQL\ub85c \ucd94\ucd9c\ud55c\ub2e4.<br \/>\n\uc774 \ubc29\uc2dd\uc73c\ub85c \ubc31\uc5c5\ud558\ub294 \uacbd\uc6b0, DB\uc5d0 TX\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294 \uc0c1\ud669\uc5d0\uc11c \ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<br \/>\n(AP \uc11c\ube44\uc2a4 \uc885\ub8cc \ud6c4 \ubc31\uc5c5\ud558\ub294 \uac83\uc744 \uad8c\uc7a5)<\/p>\n<h2>Usage<\/h2>\n<h3>\uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5<\/h3>\n<pre><code class=\"bash\">mysqldump -uroot -p -A &gt; full_database.sql\n<\/code><\/pre>\n<h3>\ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5<\/h3>\n<pre><code class=\"bash\">mysqldump -uroot -p specific_database_name &gt; specific_database_name.sql\n<\/code><\/pre>\n<h3>\ud2b9\uc815 \ud14c\uc774\ube14 \ubc31\uc5c5<\/h3>\n<pre><code class=\"bash\">mysqldump -uroot -p specific_db_name specific_table_name &gt; specific_table.sql\n<\/code><\/pre>\n<h3>\ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 Schema \uc815\ubcf4\ub9cc \ubc31\uc5c5<\/h3>\n<pre><code class=\"bash\">mysqldump -uroot -p --no-data specific_database_name &gt; specific_database_schema_only.sql\n<\/code><\/pre>\n<h2>Example<\/h2>\n<pre><code class=\"bash\">#!\/bin\/bash\n\nDUMP_DATE=<code>date +%Y%m%d%H%M<\/code>\nDUMP_PROC=\/usr\/mysql\/bin\/mysqldump\nMYSQL_USER=root\nMYSQL_PASS=MY_PASSWORD\nDUMP_FILE=\"\/backup\/mysql\/mysqldump.${DUMP_DATE}.sql\"\nEXEC_OPTS=\"-u${MYSQL_USER} -p${MYSQL_PASS} -A\"\n\n#Execution\necho \"exec ${DUMP_PROC} ${EXEC_OPTS} 2&gt;\/dev\/null &gt; ${DUMP_FILE}\"\n${DUMP_PROC} ${EXEC_OPTS} 2&gt;\/dev\/null &gt; ${DUMP_FILE}\necho \"gzip -9 ${DUMP_FILE}\"\n\/bin\/gzip -9 ${DUMP_FILE}\n<\/code><\/pre>\n<h2>\ubcf5\uad6c\ud558\uae30<\/h2>\n<pre><code class=\"bash\">mysql -uroot -p &lt; ${DUMPED_FILE}\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>mysqldump mysqldump \ud504\ub85c\uc138\uc2a4\uac00 \uc2e4\ud589\ub41c \uc21c\uac04\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8 \ubc0f \ub370\uc774\ud130\ub97c SQL\ub85c \ucd94\ucd9c\ud55c\ub2e4. \uc774 \ubc29\uc2dd\uc73c\ub85c \ubc31\uc5c5\ud558\ub294 \uacbd\uc6b0, DB\uc5d0 TX\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294 \uc0c1\ud669\uc5d0\uc11c \ud558\ub294 \uac83\uc774 \uc88b\ub2e4. (AP \uc11c\ube44\uc2a4 \uc885\ub8cc \ud6c4 \ubc31\uc5c5\ud558\ub294 \uac83\uc744 \uad8c\uc7a5) Usage \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5 mysqldump -uroot -p -A &gt; full_database.sql \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5 mysqldump -uroot -p specific_database_name &gt; specific_database_name.sql \ud2b9\uc815 \ud14c\uc774\ube14 \ubc31\uc5c5 mysqldump -uroot -p [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62],"tags":[136,110],"class_list":["post-384","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-backup","tag-mysql"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=384"}],"version-history":[{"count":4,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/384\/revisions"}],"predecessor-version":[{"id":1240,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/384\/revisions\/1240"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}