{"id":140,"date":"2015-12-08T08:01:10","date_gmt":"2015-12-08T08:01:10","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=140"},"modified":"2016-04-01T01:10:03","modified_gmt":"2016-03-31T16:10:03","slug":"mysqlwindows-scheduler-mysql-data-backup-deletion","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2015\/12\/08\/mysqlwindows-scheduler-mysql-data-backup-deletion\/","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":"

\u200b<\/a><\/p>\n

<\/div>\n
<\/div>\n
[MySQL,windows] \uc791\uc5c5\uc2a4\ucf00\uc904\ub7ec\ub97c \uc774\uc6a9\ud55c MySQL\ubc31\uc5c5 \ubc0f \ub370\uc774\ud130 \uc0ad\uc81c<\/div>\n
<\/div>\n
<\/div>\n
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<\/div>\n
<\/div>\n
\u00a0 1-1. \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d \ucee4\uba58\ub4dc<\/div>\n
SCHTASKS \/Create \/SC MONTHLY \/MO first \/D SUN \/ST 00:01 \/TN MySQL_BackUp \/TR D:\\db_bakup\\bakup.bat<\/div>\n
<\/div>\n
\u00a0[\ud480\uc774]<\/div>\n
<\/div>\n
\u00a0 \/Create : \uc2a4\ucf00\uc904\ub7ec \uc2e0\uaddc<\/div>\n
<\/div>\n
\u00a0 \/SC MONTHLY : \ub9e4\uc6d4<\/div>\n
<\/div>\n
\u00a0 \/MO fist : \uccab\ubc88\uc9f8<\/div>\n
<\/div>\n
\u00a0 \/D SUN : \uc77c\uc694\uc77c<\/div>\n
<\/div>\n
\u00a0\u00a0\/ST 00:01 : \uc2a4\ud0c0\ud2b8 \uc2dc\uac04\uc740 \uc624\uc80400:01\ubd84<\/div>\n
<\/div>\n
\u00a0 \/TN MySQL_BackUp : \uc2a4\ucf00\uc904\ub7ec \uc774\ub984<\/div>\n
<\/div>\n
\u00a0 \/TR D:\\db_bakup\\bakup.bat : \uc2e4\ud589\ud560 \ud504\ub85c\uadf8\ub7a8\uc758 \uacbd\ub85c \ubc0f \ud30c\uc77c \uc774\ub984<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u00a0 1-2.bakup.bat \ubc30\uce58\ud30c\uc77c \ub0b4\uc6a9<\/div>\n
@echo off<\/div>\n
echo Start Bakup…<\/div>\n
mysqldump -u\uc0ac\uc6a9\uc790\uba85 -p\ube44\ubc00\ubc88\ud638 –result-file=”D:\\db_bakup\\backup.%date%.sql” \ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85<\/div>\n
echo End Bakup…<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
2.\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\u00a0\uc608\uc81c<\/div>\n
<\/div>\n
\u00a0 2-1. \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d \ucee4\uba58\ub4dc<\/div>\n
SCHTASKS \/Create \/SC MONTHLY \/MO first \/D SUN \/ST 00:10 \/TN MySQL_Delete \/TR D:\\db_bakup\\data_del.bat<\/div>\n
<\/div>\n
[\ud480\uc774]<\/div>\n
<\/div>\n
1.\ubc88\uacfc \ub3d9\uc77c<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u00a0 2-2. data_del.bat \ubc30\uce58\ud30c\uc77c \ub0b4\uc6a9<\/div>\n
mysql -u\uc720\uc800ID -p\uc720\uc800\ud328\uc2a4\uc6cc\ub4dc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85 -e “delete from \ud14c\uc774\ube14\uba85 where \ub0a0\uc9dc\uceec\ub7fc <= date_sub(curdate(), INTERVAL 1 MONTH);”<\/div>\n
<\/div>\n
\u00a0[\ud480\uc774]<\/div>\n
<\/div>\n
-e “delete from \ud14c\uc774\ube14\uba85 where \ub0a0\uc9dc\uceec\ub7fc <= date_sub(curdate(), INTERVAL 1 MONTH);”<\/div>\n
: \uc2e4\ud589 \uc2dc\ud0ac \ucee4\ub9e8\ub4dc<\/div>\n","protected":false},"excerpt":{"rendered":"

\u200b [MySQL,windows] \uc791\uc5c5\uc2a4\ucf00\uc904\ub7ec\ub97c \uc774\uc6a9\ud55c MySQL\ubc31\uc5c5 \ubc0f \ub370\uc774\ud130 \uc0ad\uc81c 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 \u00a0 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 \u00a0[\ud480\uc774] \u00a0 \/Create : \uc2a4\ucf00\uc904\ub7ec \uc2e0\uaddc \u00a0 \/SC MONTHLY : \ub9e4\uc6d4 \u00a0 \/MO fist : \uccab\ubc88\uc9f8 \u00a0 \/D SUN […]<\/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-140","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\/140","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=140"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"predecessor-version":[{"id":141,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/140\/revisions\/141"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}