#!/bin/bash

fatal () {
    echo "Error! $*"
    exit 1
}

. /usr/local/bin/backupcommon ||
    fatal "Can not find common settings!"

if [ "$1" = '-b' ] ; then # Optionally, make a backup before we start...
    # I'm not sure how useful this is, since both recover and analyze
    # are pretty safe operations...
    /usr/local/bin/mythbackup ||
        fatal "Backup failed! Aborting!"
fi
# The database needs to be idle when we do this...
# Having it auto restarted would also be "bad". ;-)
/etc/init.d/mythtv-backend stop
/etc/init.d/mysql stop

cd $DATABASE_DIR || fatal "Could not cd to $DATABASE_DIR"

for tbl in *.MYI ; do
    # If the fast way fails fall back on the old slow way.
    myisamchk --recover $tbl || {
        echo "Fast recovery of $tbl failed, attempting slower safe recovery..."
        myisamchk --safe-recover $tbl ||
            fatal "Even safe recovery of $tbl failed! Aborting!"
    }
    myisamchk --analyze $tbl
done

# Resatart the servers in the right order...
/etc/init.d/mysql restart
/etc/init.d/mythtv-backend restart

•   Look in your script for a command that reads something like
      â€œlynx -dump http://localhost:6544â€?
•   Replace that command with
      â€œlynx -dump http://localhost/mythweb/settingsâ€?
•   The script may grep an output file for a specific string such as “Scheduleâ€?.
   If your script does this, replace the search string with the following:
         â€œThis is the index pageâ€?

/etc/init.d/mysql start
/etc/init.d/mythtv-backend start

#!/usr/bin/perl -w
#
# $Date: 2005-08-20 13:21:40 -0700 (Sat, 20 Aug 2005) $
# $Revision: 7095 $
# $Author: xris $
#
#  epair_optimize.pl:
#
#   Connects to the mythtv database and repairs/optimizes the tables that it
#   finds.  Suggested use is to cron it to run once per day.
#

# Load DBI
    use DBI;

# Some variables we'll use here
    my ($db_host, $db_user, $db_name, $db_pass);

# Read the mysql.txt file in use by MythTV.
# could be in a couple places, so try the usual suspects
    my $found = 0;
    my @mysql = ('/usr/local/share/mythtv/mysql.txt',
                 '/usr/share/mythtv/mysql.txt',
                 '/etc/mythtv/mysql.txt',
                 '/usr/local/etc/mythtv/mysql.txt',
                 "$ENV{HOME}/.mythtv/mysql.txt",
                 'mysql.txt'
                );
    foreach my $file (@mysql) {
        next unless (-e $file);
        $found = 1;
        open(CONF, $file) or die "Unable to open $file:  $!\n\n";
        while (my $line = <CONF>) {
        # Cleanup
            next if ($line =~ /^\s*#/);
            $line =~ s/^str //;
            chomp($line);
        # Split off the var=val pairs
            my ($var, $val) = split(/\=/, $line, 2);
            next unless ($var && $var =~ /\w/);
            if ($var eq 'DBHostName') {
                $db_host = $val;
            }
            elsif ($var eq 'DBUserName') {
                $db_user = $val;
            }
            elsif ($var eq 'DBName') {
                $db_name = $val;
            }
            elsif ($var eq 'DBPassword') {
                $db_pass = $val;
            }
        }
        close CONF;
    }
    die "Unable to locate mysql.txt:  $!\n\n" unless ($found && $db_host);

# Connect to the database
    $dbh = DBI->connect("dbi:mysql:database=$db_name:host=$db_host", $db_user, $db_pass)
        or die "Cannot connect to database: $!\n\n";

# Repair and optimize each table
    foreach $table ($dbh->tables) {
        unless ($dbh->do("REPAIR TABLE $table")) {
            print "Skipped:  $table\n";
            next;
        };
        if ($dbh->do("OPTIMIZE TABLE $table")) {
            print "Repaired/Optimized: $table\n";
        }
    }

# Close the database connection
    $dbh->disconnect;

mythtv@mythbox:~$ cat .mythtv/mysql.txt
DBHostName=192.168.11.4
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

# Set the following if you want to use something other than the
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise
# you'll need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
LocalHostName=mythbox

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
# Set the time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#WOLsqlReconnectWaitTime=0
#
#
# This is the amount of retries to wake the MySQL server until the frontend
# gives up
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'

mythtv@mythbox:~$ mysql -V
mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

root@black2:~# hd scripts/backup/optimize_db.sh | tail
000003a0  6b 20 2d 2d 61 6e 61 6c  79 7a 65 20 24 74 62 6c  |k --analyze $tbl|
000003b0  0a 64 6f 6e 65 0a 0a 23  20 52 65 73 61 74 61 72  |.done..# Resatar|
000003c0  74 20 74 68 65 20 73 65  72 76 65 72 73 20 69 6e  |t the servers in|
000003d0  20 74 68 65 20 72 69 67  68 74 20 6f 72 64 65 72  | the right order|
000003e0  2e 2e 2e 0a 2f 65 74 63  2f 69 6e 69 74 2e 64 2f  |..../etc/init.d/|
000003f0  6d 79 73 71 6c 20 72 65  73 74 61 72 74 0a 2f 65  |mysql restart./e|
00000400  74 63 2f 69 6e 69 74 2e  64 2f 6d 79 74 68 74 76  |tc/init.d/mythtv|
00000410  2d 62 61 63 6b 65 6e 64  20 72 65 73 74 61 72 74  |-backend restart|
00000420  0a                                                |.|
00000421

root@mythtv:/usr/local/bin# hd /usr/local/bin/optimize_db.sh | tail
000003a0  68 6b 20 2d 2d 61 6e 61  6c 79 7a 65 20 24 74 62  |hk --analyze $tb|
000003b0  6c 0a 64 6f 6e 65 0a 0a  23 20 52 65 73 61 74 61  |l.done..# Resata|
000003c0  72 74 20 74 68 65 20 73  65 72 76 65 72 73 20 69  |rt the servers i|
000003d0  6e 20 74 68 65 20 72 69  67 68 74 20 6f 72 64 65  |n the right orde|
000003e0  72 2e 2e 2e 0a 2f 65 74  63 2f 69 6e 69 74 2e 64  |r..../etc/init.d|
000003f0  2f 6d 79 73 71 6c 20 72  65 73 74 61 72 74 0a 2f  |/mysql restart./|
00000400  65 74 63 2f 69 6e 69 74  2e 64 2f 6d 79 74 68 74  |etc/init.d/mytht|
00000410  76 2d 62 61 63 6b 65 6e  64 20 72 65 73 74 61 72  |v-backend restar|
00000420  74 0a                                             |t.|
00000422
root@mythtv:/usr/local/bin#

/etc/init.d/mythtv-backend restart

/etc/init.d/mythtv-backend stop
/etc/init.d/mythtv-backend start

root@black2:~# diff -c /etc/init.d/mythtv-backend~ /etc/init.d/mythtv-backend
*** /etc/init.d/mythtv-backend~ Wed Nov 14 22:44:52 2007
--- /etc/init.d/mythtv-backend  Wed Nov 14 22:45:28 2007
***************
*** 56,62 ****
    restart|force-reload)
        echo -n "Restarting $DESC: $NAME"
        start-stop-daemon --stop --oknodo --pidfile $RUNDIR/$NAME.pid \
!                 --chuid $USER --exec $DAEMON -- $ARGS
        echo "."
        sleep 3
        start-stop-daemon --start --pidfile $RUNDIR/$NAME.pid \
--- 56,62 ----
    restart|force-reload)
        echo -n "Restarting $DESC: $NAME"
        start-stop-daemon --stop --oknodo --pidfile $RUNDIR/$NAME.pid \
!                 --chuid $USER --exec $DAEMON -- $ARGS || : ignore any errors
        echo "."
        sleep 3
        start-stop-daemon --start --pidfile $RUNDIR/$NAME.pid \