HTN20190109 https://blog.hatena.ne.jp/HTN20190109/ HTN20190109の日記 https://htn20190109.hatenablog.com/ DB MySQL (8.0.21) -- エクスポートの場合vim /etc/my.cnfsecure_file_priv="/tmp"systemctl restart mysqldshow variables like 'secure_file_priv'; select * into outfile '/tmp/tab1.csv'fields terminated by ',' optionally enclosed by '"'from tab1; →実行可能 -- バックアップの場合mysqldump -u root test -p --quick --dump-slave=2 --flu… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2020%2F12%2F30%2F162402" title="スタンバイからのエクスポート - HTN20190109の日記" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2020-12-30 16:24:02 rich https://htn20190109.hatenablog.com/entry/2020/12/30/162402 1.0 100%