rendered paste body#!/bin/bash### Needs more checking?### Needs to notify admin that it's run?### Needs testing? How can create crached databases?### User-definable AliasesDATABASE_DIR=/var/lib/mysql/mythconvergCHECK_COMMAND=$(myisamchk --update-state -s *.MYI)FIX_COMMAND=$(myisamchk -r)MYSQLD=/etc/init.d/mysqlMYTHTV_BACKEND=/etc/init.d/mythtv-backed### Functionsfunction stop_services { $MYSQLD stop $MYTHTV_BACKEND stop}function start_services { $MYSQLD start $MYTHTV_BACKEND start}function grab_broken { BROKEN_DATABASES=$($CHECK_COMMAND | grep MYI | grep myisamchk | cut -d' ' -f4)}function fix_broken { while read LINE do $FIX_COMMAND "$LINE" done <<< "$BROKEN_DATABASES"}#### Mainstop_servicesgrab_brokenfix_brokenstart_services