#!/bin/bash

HELP="$0 db table"

DB=${1?Missing database to check
$HELP
}

TABLE=${2?Missing table in $DB to check
$HELP
}

if ! pgrep -x 'mysql[d]' >/dev/null
then
    #  Can't check via server if server not up!
    exit 100
fi

db() {
    echo "$*" | mysql -u root -s $DB
    return 0;
}

OUTPUT="$(db "CHECK TABLE $TABLE" 2>&1)"

if echo "$OUTPUT" | egrep -q "doesn't support check"
then
    exit 200
elif ! echo "$OUTPUT" | egrep -q 'status.*OK'
then

    cat <<EOF
Errors encountered with $DB.$TABLE:

$OUTPUT

EOF
    db "REPAIR TABLE $TABLE"

fi

exit 0