#!/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