{"id":30,"date":"2015-12-08T06:26:39","date_gmt":"2015-12-08T06:26:39","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=30"},"modified":"2016-04-01T00:28:01","modified_gmt":"2016-03-31T15:28:01","slug":"mysqlwindows-scheduler-data-backup-restore-manage","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2015\/12\/08\/mysqlwindows-scheduler-data-backup-restore-manage\/","title":{"rendered":"[MySQL,windows] \uc791\uc5c5\uc2a4\ucf00\uc904\ub7ec\ub97c \uc774\uc6a9\ud55c MySQL\ubc31\uc5c5 \ubc0f \ub370\uc774\ud130 \uc0ad\uc81c"},"content":{"rendered":"<p>\u200b<\/p>\n<p>1.MySQL\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9e4\uc6d4 \uccab\ubc88\uc9f8 \uc77c\uc694\uc77c \uc624\uc804 00:01\ubd84\uc5d0 \ubc31\uc5c5\ud558\ub294 \uc608\uc81c<br \/>\n1-1. \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d \ucee4\uba58\ub4dc<br \/>\nSCHTASKS \/Create \/SC MONTHLY \/MO first \/D SUN \/ST 00:01 \/TN MySQL_BackUp \/TR D:\\db_bakup\\bakup.bat<br \/>\n[\ud480\uc774]<br \/>\n\/Create : \uc2a4\ucf00\uc904\ub7ec \uc2e0\uaddc<br \/>\n\/SC MONTHLY : \ub9e4\uc6d4<br \/>\n\/MO fist : \uccab\ubc88\uc9f8<br \/>\n\/D SUN : \uc77c\uc694\uc77c<br \/>\n\/ST 00:01 : \uc2a4\ud0c0\ud2b8 \uc2dc\uac04\uc740 \uc624\uc80400:01\ubd84<br \/>\n\/TN MySQL_BackUp : \uc2a4\ucf00\uc904\ub7ec \uc774\ub984<br \/>\n\/TR D:\\db_bakup\\bakup.bat : \uc2e4\ud589\ud560 \ud504\ub85c\uadf8\ub7a8\uc758 \uacbd\ub85c \ubc0f \ud30c\uc77c \uc774\ub984<\/p>\n<p>1-2.bakup.bat \ubc30\uce58\ud30c\uc77c \ub0b4\uc6a9<br \/>\n@echo off<br \/>\necho Start Bakup&#8230;<br \/>\nmysqldump -u\uc0ac\uc6a9\uc790\uba85 -p\ube44\ubc00\ubc88\ud638 &#8211;result-file=&#8221;D:\\db_bakup\\backup.%date%.sql&#8221; \ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85<br \/>\necho End Bakup&#8230;<br \/>\n2.\uc704\uc5d0\uc11c \ubc31\uc5c5\uc744 \ud55c\ud6c4 \ud604\uc2dc\uc810\uc73c\ub85c\ud574\uc11c 1\uac1c\uc6d4 \uc774\uc804\uc758 \ub370\uc774\ud130\ub97c \ub9e4\uc6d4 \uccab\ubc88\uc9f8 \uc77c\uc694\uc77c \uc624\uc804 00:10\ubd84\uc5d0 \uc9c0\uc6b0\uae30 \uc608\uc81c<br \/>\n2-1. \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d \ucee4\uba58\ub4dc<br \/>\nSCHTASKS \/Create \/SC MONTHLY \/MO first \/D SUN \/ST 00:10 \/TN MySQL_Delete \/TR D:\\db_bakup\\data_del.bat<br \/>\n[\ud480\uc774]<br \/>\n1.\ubc88\uacfc \ub3d9\uc77c<br \/>\n2-2. data_del.bat \ubc30\uce58\ud30c\uc77c \ub0b4\uc6a9<br \/>\nmysql -u\uc720\uc800ID -p\uc720\uc800\ud328\uc2a4\uc6cc\ub4dc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85 -e &#8220;delete from \ud14c\uc774\ube14\uba85 where \ub0a0\uc9dc\uceec\ub7fc &lt;= date_sub(curdate(), INTERVAL 1 MONTH);&#8221;<br \/>\n[\ud480\uc774]<br \/>\n-e &#8220;delete from \ud14c\uc774\ube14\uba85 where \ub0a0\uc9dc\uceec\ub7fc &lt;= date_sub(curdate(), INTERVAL 1 MONTH);&#8221;<br \/>\n: \uc2e4\ud589 \uc2dc\ud0ac \ucee4\ub9e8\ub4dc<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u200b 1.MySQL\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9e4\uc6d4 \uccab\ubc88\uc9f8 \uc77c\uc694\uc77c \uc624\uc804 00:01\ubd84\uc5d0 \ubc31\uc5c5\ud558\ub294 \uc608\uc81c 1-1. \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d \ucee4\uba58\ub4dc SCHTASKS \/Create \/SC MONTHLY \/MO first \/D SUN \/ST 00:01 \/TN MySQL_BackUp \/TR D:\\db_bakup\\bakup.bat [\ud480\uc774] \/Create : \uc2a4\ucf00\uc904\ub7ec \uc2e0\uaddc \/SC MONTHLY : \ub9e4\uc6d4 \/MO fist : \uccab\ubc88\uc9f8 \/D SUN : \uc77c\uc694\uc77c \/ST 00:01 : \uc2a4\ud0c0\ud2b8 \uc2dc\uac04\uc740 \uc624\uc80400:01\ubd84 \/TN MySQL_BackUp : \uc2a4\ucf00\uc904\ub7ec [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-30","post","type-post","status-publish","format-standard","hentry","category-mariadb-mysql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":2,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"predecessor-version":[{"id":382,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/30\/revisions\/382"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}