diff options
| author | Silvio Rhatto <rhatto@riseup.net> | 2014-03-17 18:32:55 -0300 |
|---|---|---|
| committer | Silvio Rhatto <rhatto@riseup.net> | 2014-03-17 18:32:55 -0300 |
| commit | b5450413341f3cfd3876e87cdbf1195da56dd8bc (patch) | |
| tree | 7b0622e4452ceaad7f1e0a4e4cd650934ce91990 | |
| parent | 27827c5c1532ab4e4d1c3b56cb7801a40174b53e (diff) | |
| download | hydra-b5450413341f3cfd3876e87cdbf1195da56dd8bc.tar.gz hydra-b5450413341f3cfd3876e87cdbf1195da56dd8bc.tar.bz2 | |
Adding mysql-repair script
| -rw-r--r-- | TODO.md | 1 | ||||
| -rwxr-xr-x | share/hydractl/mysql-repair | 14 |
2 files changed, 15 insertions, 0 deletions
@@ -15,3 +15,4 @@ Hydractl - backup-restore-user and backup-restore-users. - hydractl backup-restore-site {debian,wiki}. - wrapper to import/export monkeysphere keys into keyringer. + - enhance mysql-repair diff --git a/share/hydractl/mysql-repair b/share/hydractl/mysql-repair new file mode 100755 index 0000000..00802c5 --- /dev/null +++ b/share/hydractl/mysql-repair @@ -0,0 +1,14 @@ +#!/bin/bash +# +# Quick and dirty database repair script! +# + +DAMAGED="`grep "Checking table" /var/log/daemon.log | cut -d "'" -f 2 | uniq`" + +for damage in $DAMAGED; do + db="`dirname $damage | sed -e 's|./||'`" + tb="`basename $damage`" + + echo "Fixing table $tb on db $db..." + echo "repair table $tb" | mysql $db +done |