<p><br></p><p><br></p><p><br></p><p><br></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: 13px; line-height: 18px; white-space: pre;"><div><span style="color: #6a9955;">#!/bin/bash</span></div><div><span style="color: #6a9955;"># 백업</span></div><div>docker <span style="color: #dcdcaa;">exec</span> mariadb /bin/bash -c <span style="color: #ce9178;">'mysqldump --single-transaction --hex-blob --routines --databases skyscape -uroot -proot'</span> | gzip &gt; /volume1/docker/blog/db_bak/skyscape-<span style="color: #ce9178;">$(date +"%Y-%m-%d")</span>.sql.gz</div><br><div><span style="color: #6a9955;"># 삭제(30일 유지)</span></div><div>find /volume1/docker/blog/db_bak/ -name <span style="color: #ce9178;">'*.sql.gz'</span> -ctime +30 -delete</div></div><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>

[Mysql & MariaDB] 도커에서 돌아가는 DB 백업하기 in Synology