{"id":738,"date":"2023-07-19T16:30:10","date_gmt":"2023-07-19T07:30:10","guid":{"rendered":"https:\/\/blog.mydepot.kr\/?p=738"},"modified":"2023-07-19T16:30:10","modified_gmt":"2023-07-19T07:30:10","slug":"%ec%8b%9c%eb%86%80%eb%a1%9c%ec%a7%80-mariadb-db%eb%b3%84-%eb%b0%b1%ec%97%85-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8-%ec%98%a4%eb%9e%98%eb%90%9c-%eb%b0%b1%ec%97%85-%ec%82%ad%ec%a0%9c","status":"publish","type":"post","link":"https:\/\/blog.mydepot.kr\/?p=738","title":{"rendered":"[\uc2dc\ub180\ub85c\uc9c0] MariaDB DB\ubcc4 \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8 + \uc624\ub798\ub41c \ubc31\uc5c5 \uc0ad\uc81c"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n#!\/bin\/bash\nDB_USER=&quot;DB\uc544\uc774\ub514&quot;\nDB_PASSWORD=&quot;DB\ube44\ubc00\ubc88\ud638&quot;\nBACKUP_DIR=&quot;\ubc31\uc5c5\uacbd\ub85c&quot;\n\nDATABASES=(&quot;\ubc31\uc5c5DB\uba851&quot; &quot;\ubc31\uc5c5DB\uba852&quot;)\n\nDATE=$(date +&quot;%Y%m%d&quot;)\nfor DATABASE in &quot;${DATABASES&#x5B;@]}&quot;\ndo\n      \/volume1\/@appstore\/MariaDB10\/usr\/local\/mariadb10\/bin\/mysqldump --user=$DB_USER --password=&quot;$DB_PASSWORD&quot; $DATABASE &gt; &quot;$BACKUP_DIR\/${DATABASE}_$DATE.sql&quot;\ndone\n\nfind &quot;$BACKUP_DIR\/&quot; -maxdepth 1 -name &quot;*.sql&quot; -type f -ctime +10 -ls -exec rm {} \\;\n<\/pre><\/div>\n\n\n<p>\uc704 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc54c\ub9de\uac8c \uc218\uc815\ud574\uc11c \uc800\uc7a5 \ud6c4, \uc791\uc5c5 \uc2a4\ucf00\uc904\ub7ec\ub97c \uc774\uc6a9\ud574\uc11c \uc8fc\uae30\uc801\uc73c\ub85c \uc2e4\ud589\ud574\uc8fc\uc790.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc704 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc54c\ub9de\uac8c \uc218\uc815\ud574\uc11c \uc800\uc7a5 \ud6c4, \uc791\uc5c5 \uc2a4\ucf00\uc904\ub7ec\ub97c \uc774\uc6a9\ud574\uc11c \uc8fc\uae30\uc801\uc73c\ub85c \uc2e4\ud589\ud574\uc8fc\uc790.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[10],"tags":[20,366,386],"class_list":["post-738","post","type-post","status-publish","format-standard","hentry","category-server","tag-20","tag-366","tag-db"],"modified_by":"\ucc38\ube5b\ubc14\ub2e4","_links":{"self":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=738"}],"version-history":[{"count":1,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/738\/revisions"}],"predecessor-version":[{"id":739,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/738\/revisions\/739"}],"wp:attachment":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}