snipt

Ctrl+h for KB shortcuts

Bash

mysql: check all tables in all databases

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
https://snipt.net/embed/6d4279ae5b219885f32e6eee51071999/
/raw/6d4279ae5b219885f32e6eee51071999/
6d4279ae5b219885f32e6eee51071999
bash
Bash
1
2019-05-24T17:10:47
True
False
False
/api/public/snipt/2043/
mysql-check-all-tables-in-all-databases
<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>mysqlcheck -u root -p --auto-repair --check --optimize --all-databases </span></pre></div> </td></tr></table>
dba, mysql, sysadmin