mysqlRepairTableFromLog.sh

#!/bin/bash
# Author: Martin PANEL
# Description: find all crashed mysql table from a log file, a run request to repair them
# Usage : mysqlRepairTableFromLog.sh [logFile]
#    logFile: file log or /var/log/syslog by default
# 
# env var $MYSQL_OPTS can be used to add mysql params
#

log=/var/log/syslog
if [ ! -z "$1" ]; then
  log="$1"
fi

tables="$(grep -i crashed "$log" | grep -i mysql | sed -r 's/.*Table ...(.+). is marked .+/\1/' | sort -u)"

request="repair table $(echo "$tables" |  tr '\/\n' '.,' | sed 's/.$//');"

echo "$request" | mysql $MYSQL_OPTS