[mythtv-users] mysql problems and how to fix them ...

[Nick Rout]

On Mon, Sep 10, 2012 at 8:16 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 09/09/2012 10:44 AM, Sebastian Niehaus wrote:
>>
>> It did not finish after 8 hours, think it is broken ...
>>
>
> Your table may be too corrupt for MySQL to fix.  IMHO it sounds like it's
> corrupt enough that you may not want to trust the data in it, even if you
> find a way to get MySQL to fix the table structure.
>
> Fortunately, recordedseek is full of re-creatable data (and has no
> non-re-creatable data).  So:
>
> mysql -umythtv -p mythconverg -e 'TRUNCATE TABLE recordedseek;'
>
> Then http://www.mythtv.org/wiki/Repairing_the_Seektable for each recording.
> You can set up a script to do that for each recording file.

I had a similar problem a few years back and followed that advice
(which IIRC came from you). Took freaking ages, I have a gruntier
backend and far more recordings now, so I predict it would still take
a while.

Worked extremely well though!