3 E=`mysql -e 'show slave status;' | grep 'Incorrect key file' | head -n1 | cut -f20 | sed -r -e "s/^.*\/(.*)\.MYI.*Default database: '([^']*)'.*$/\2 \1/"`
4 DN=`echo $E | cut -d\ -f1`
5 TN=`echo $E | cut -d\ -f2`
7 if [ ! -z "$DN" ]; then
8 if [ ! -z "$TN" ]; then
9 mysql -e "repair table $TN; slave start;" $DN