把指定DB的SQL檔案匯出到local:
$ docker exec {CONTAINER} /usr/bin/mysqldump -u root --password=xxx {DATABASE} > backup.sql
只匯出db結構 add -d:
$ docker exec {CONTAI

學習

健康與情感

創作

<div class="draft-block draft--p left">把指定DB的SQL檔案匯出到local:<br>$ docker exec {CONTAINER} /usr/bin/mysqldump -u root --password=xxx {DATABASE} &gt; backup.sql</div>
<div class="draft-block draft--p left">只匯出db結構 add -d:<br>$ docker exec {CONTAINER} /usr/bin/mysqldump <span style="font-weight: bold; ">-d</span> -u root --password=xxx {DATABASE} &gt; backup.sql</div>
<div class="draft-block draft--p left"></div>
<div class="draft-block draft--p left"><span style="font-style: italic; ">本筆記參考:<br>1. </span><a href="https://gist.github.com/spalladino/6d981f7b33f6e0afe6bb" target="_blank" class="draft--a"><span style="font-style: italic; ">https://gist.github.com/spalladino/6d981f7b33f6e0afe6bb</span></a></div>

<p>把指定DB的SQL檔案匯出到local:<br>
$ docker exec {CONTAINER} /usr/bin/mysqldump -u root --password=xxx {DATABASE} &gt; backup.sql</p>
<p>只匯出db結構 add -d:<br>
$ docker exec {CONTAINER} /usr/bin/mysqldump <strong>-d</strong> -u root --password=xxx {DATABASE} &gt; backup.sql</p>
<p><br></p>
<p><em>本筆記參考:<br>
1. </em><a href="https://gist.github.com/spalladino/6d981f7b33f6e0afe6bb"><em>https://gist.github.com/spalladino/6d981f7b33f6e0afe6bb</em></a></p>

把指定DB的SQL檔案匯出到local:
$ docker exec {CONTAINER} /usr/bin/mysqldump -u root --password=xxx {DATABASE} > backup.sql

只匯出db結構 add -d:
$ docker exec {CONTAINER} /usr/bin/mysqldump -d -u root --password=xxx {DATABASE} > backup.sql

匯出docker中的mysql 資料