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

[Michael T. Dean]

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.

Mike