misc /sbin utils

[sql.git] / sbin / repair

diff --git a/sbin/repair b/sbin/repair
new file mode 100755 (executable)
index 0000000..a6416e2
--- /dev/null
+++ b/sbin/repair
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+E=`mysql -e 'show slave status;' | grep 'Incorrect key file' | head -n1 | cut -f20 | sed -r -e "s/^.*\/(.*)\.MYI.*Default database: '([^']*)'.*$/\2 \1/"`
+DN=`echo $E | cut -d\  -f1`
+TN=`echo $E | cut -d\  -f2`
+
+if [ ! -z "$DN" ]; then
+    if [ ! -z "$TN" ]; then
+        mysql -e "repair table $TN; slave start;" $DN
+    fi
+fi