From b5450413341f3cfd3876e87cdbf1195da56dd8bc Mon Sep 17 00:00:00 2001
From: Silvio Rhatto <rhatto@riseup.net>
Date: Mon, 17 Mar 2014 18:32:55 -0300
Subject: Adding mysql-repair script

---
 share/hydractl/mysql-repair | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100755 share/hydractl/mysql-repair

(limited to 'share/hydractl')

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
-- 
cgit v1.2.3