[mythtv-users] mysql problems and how to fix them ...
Michael T. Dean
mtdean at thirdcontact.com
Sun Sep 9 20:16:00 UTC 2012
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.
More information about the mythtv-users