#!/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)

### Functions
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
grab_broken
fix_broken