#!/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
rm $TEMP_FILE