출처 :&nbsp;<a href="https://www.reddit.com/r/BookStack/comments/ix9iu4/backup_bookstack_database_using_mysqldump_when/" target="_blank">https://www.reddit.com/r/BookStack/comments/ix9iu4/backup_bookstack_database_using_mysqldump_when/</a> 나스에서 도커 컨테이너로 mariadb를 동작시키고 있는데, 주기적으로 백업을 하고 싶었다. <div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div>#&nbsp;컨테이너&nbsp;안에&nbsp;백업할&nbsp;파일을&nbsp;만드려면&nbsp;아래와&nbsp;같이할&nbsp;수&nbsp;있다.&nbsp;</div><div>docker&nbsp;exec&nbsp;{{mariadb_container_name}}&nbsp;/bin/bash&nbsp;-c&nbsp;'mysqldump&nbsp;--single-transaction&nbsp;--hex-blob&nbsp;--routines&nbsp;--databases&nbsp;{{database_name}}&nbsp;-u{{mysql_user}}&nbsp;-p{{mysql_password}}&nbsp;|&nbsp;gzip&nbsp;&gt;&nbsp;/volume1/db_bak/database-$(date&nbsp;+"%Y-%m-%d").sql.gz'</div> <div>#&nbsp;호스트에&nbsp;백업파일을&nbsp;만드려면&nbsp;아래와&nbsp;같이&nbsp;작은&nbsp;따옴표의&nbsp;위치를&nbsp;변경해야&nbsp;한다</div><div>docker&nbsp;exec&nbsp;{{mariadb_container_name}}&nbsp;/bin/bash&nbsp;-c&nbsp;'mysqldump&nbsp;--single-transaction&nbsp;--hex-blob&nbsp;--routines&nbsp;--databases&nbsp;{{database_name}}&nbsp;-u{{mysql_user}}&nbsp;-p{{mysql_password}}'&nbsp;|&nbsp;gzip&nbsp;&gt;&nbsp;/volume1/db_bak/database-$(date&nbsp;+"%Y-%m-%d").sql.gz</div> <div>#&nbsp;참고로&nbsp;docker&nbsp;exec&nbsp;-it&nbsp;옵션을&nbsp;주고&nbsp;실행했더니&nbsp;작업스케줄러에서&nbsp;정상적으로&nbsp;std&nbsp;out을&nbsp;가져오지&nbsp;못하였다.</div></div>

[Synology] docker 컨테이너의 mariadb 자동 백업하기