[mythtv-users] Broken recordedseek table - what next?

[Nick Rout]

I noted from a frontend log that the recordedseek table is corrupt
(hence the kids complaining that seeking isn't working) I manually run
the mythbuntu supplied /etc/cron.weekly/mythtv-database (reproduced
below) and I get the following output:

mythconverg.recordedseek
warning  : Table is marked as crashed and last repair failed
warning  : Size of indexfile is: 104631296      Should be: 50863104
error    : Key in wrong position at page 39012352
error    : Corrupt

What now? Is there a way to repair it?

the cron script is below:


#!/bin/sh
# /etc/cron.weekly/mythtv-database script - check and backup mythconverg tables
# Copyright 2005/12/02 2006/10/08 Paul Andreassen
#                      2010 Mario Limonciello

set -e -u

DBNAME="mythconverg"
DEBIAN="--defaults-extra-file=/etc/mysql/debian.cnf"

/usr/bin/mysqlcheck $DEBIAN -s $DBNAME

/usr/share/mythtv/mythconverg_backup.pl

/usr/bin/logger -p daemon.info -i -t${0##*/} "$DBNAME checked and backedup."

# End of file.