rendered paste body#!/bin/bash
### User-definable Aliases
DATABASE_DIR=/var/lib/mysql/mythconverg
CHECK_COMMAND=$(myisamchk --update-state -s *.MYI)
TEMPFILE=/tmp/brokendatabases
FIX_COMMAND=$(myisamchk -r)
MYSQLD=/etc/init.d/mysql
MYTHTV_BACKEND=/etc/init.d/mythtv-backed
### Functions
function stop_services {
$MYSQLD stop
$MYTHTV_BACKEND stop
}
function start_services {
$MYSQLD start
$MYTHTV_BACKEND start
}
function grab_broken {
$CHECK_COMMAND | grep MYI | grep myisamchk | cut -d' ' -f4 > $TEMP_FILE
}
function fix_broken {
while read LINE
do
$FIX_COMMAND "$LINE"
done < "$TEMP_FILE"
}
#### Main
stop_services
grab_broken
fix_broken
start_services