<p><br></p><p>적당한 곳에 쉘 파일 작성</p><p>db-back.sh</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: D2Coding, Consolas, &quot;Courier New&quot;, monospace, Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">#!/bin/bash</span></div><br><div>curDate=<span style="color: #ce9178;">`date +%Y%m%d</span><span style="color: rgb(206, 145, 120);">-%H%M%S</span><span style="color: rgb(206, 145, 120);">`</span></div><br><div><span style="color: #6a9955;"># 백업</span></div><div>/bin/mysqldump --single-transaction --hex-blob --routines -uroot -p1234 --databases mydb -h localhost | gzip &gt; /home/nwkim/db-backup/mydb-${<span style="color: #9cdcfe;">curDate</span>}.sql.gz</div><br><div><span style="color: #6a9955;"># 삭제(30일 지나면 삭제)</span></div><div>find /home/nwkim/db-backup -name <span style="color: #ce9178;">'*.sql.gz'</span> -ctime +30 -delete</div><br></div><p><br></p><p><br></p><p>crontab 작성</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: D2Coding, Consolas, &quot;Courier New&quot;, monospace, Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;"># 매일 0시에 동작</span></div><div>0 0 * * * /home/nwkim/cronjob/db-back.sh</div></div><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>

[MySQL & MariaDB] 크론탭을 사용한 자동 백업 backup with crontab