[mythtv-users] Database Error

[Michael T. Dean]

On 05/17/2011 12:50 AM, Frank Phillips wrote:
> On Mon, May 16, 2011 at 11:07 PM, Ken Mandelberg wrote:
>> I'm getting the error
>>
>> 2011-05-17 00:01:41.336 Driver error was [2/144]:
>> QMYSQL3: Unable to prepare statement
>> Database error was:
>> Table './mythconverg/recordedseek' is marked as crashed and last
>> (automatic?) repair failed
>>
>> 2011-05-17 00:01:41.344 DB Error (delta position map insert):
>> Query was:
>> INSERT INTO recordedseek (chanid, starttime, mark, type, offset)  VALUES (
>> :CHANID , :STARTTIME , :MARK , :TYPE , :OFFSET )
>>
>>
>> What can I do to repair it?
> You can try mysqlcheck -Ap --auto-repair, followed by the mysql root user
> password.

Or just run optimize_mythdb.pl (I run it on a daily cron at a time when 
I'm unlikely to be recording anything).

Mike