snipt

Ctrl+h for KB shortcuts

Bash

schedule weekly backup

mysql-zrm-scheduler --add --interval weekly --backup-set weeklyrun --start 3:00 --backup-level 0
https://snipt.net/embed/30b1de243dccb1ef943b5450013118e6/
/raw/30b1de243dccb1ef943b5450013118e6/
30b1de243dccb1ef943b5450013118e6
bash
Bash
1
2019-05-12T12:51:20
True
False
False
/api/public/snipt/1346/
schedule-weekly-backup
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>mysql-zrm-scheduler --add --interval weekly --backup-set weeklyrun --start 3:00 --backup-level 0 </span></pre></div> </td></tr></table>
mysql, mysql-zrm

Bash

schedule daily backup

mysql-zrm-scheduler --add --interval daily --backup-set dailyrun --start 1:00 --backup-level 0
https://snipt.net/embed/ab489175b79961ca422227c55d8a51f7/
/raw/ab489175b79961ca422227c55d8a51f7/
ab489175b79961ca422227c55d8a51f7
bash
Bash
1
2019-05-15T02:38:03
True
False
False
/api/public/snipt/1345/
schedule-daily-backup
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>mysql-zrm-scheduler --add --interval daily --backup-set dailyrun --start 1:00 --backup-level 0 </span></pre></div> </td></tr></table>
mysql, mysql-zrm

Bash

run daily mysql-zrm backup now

mysql-zrm-scheduler --now --backup-set dailyrun --backup-level 0
https://snipt.net/embed/0135cd882c98cb78632d7c8117ca740d/
/raw/0135cd882c98cb78632d7c8117ca740d/
0135cd882c98cb78632d7c8117ca740d
bash
Bash
1
2019-05-18T19:12:00
True
False
False
/api/public/snipt/1344/
run-daily-mysql-zrm-backup-now
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>mysql-zrm-scheduler --now --backup-set dailyrun --backup-level 0 </span></pre></div> </td></tr></table>
mysql, mysql-zrm

Bash

query msyql backups

mysql-zrm-reporter --where backup-set=dailyrun --show backup-status-info
https://snipt.net/embed/4cd2e2f0a31cab3dfc994928fdfdefb3/
/raw/4cd2e2f0a31cab3dfc994928fdfdefb3/
4cd2e2f0a31cab3dfc994928fdfdefb3
bash
Bash
1
2019-05-12T14:30:47
True
False
False
/api/public/snipt/1343/
query-msyql-backups
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>mysql-zrm-reporter --where backup-set<span class="o">=</span>dailyrun --show backup-status-info </span></pre></div> </td></tr></table>
mysql, mysql-zrm

Bash

query mysql scheduled backups

mysql-zrm-scheduler --query
https://snipt.net/embed/1bba78ec0735ea7d51468584c0e9528c/
/raw/1bba78ec0735ea7d51468584c0e9528c/
1bba78ec0735ea7d51468584c0e9528c
bash
Bash
1
2019-05-12T06:54:07
True
False
False
/api/public/snipt/1342/
query-mysql-backups
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a>mysql-zrm-scheduler --query </span></pre></div> </td></tr></table>
mysql, mysql-zrm