[mythtvnz] Seek on all recordings kaput...

[Matt Poff]

Bit of a late addition to my own query here but thought it might be  
useful to reference this howto which solved my problem (as the article  
points out - all database repair efforts were ineffective until I did  
the following:

Stop the database.
Run: $> myisamchk -nr /var/lib/mysql/mythconverg/recordedseek.MYI
Start database and log-in
Run SQL command: REPAIR TABLE recordedseek;
Exit database
Run: $> mythcommflag --rebuild

Full post: http://www.mythtvtalk.com/forum/archive/o_t/t_5884




On 2/09/2008, at 9:54 PM, Graeme Woollett wrote:

> Duncan Kennington wrote:
>> Try running the commercial flagger over one of the recordings again -
>> that should recalculate the recordedseek table.  If not check the
>> contents of recordedseek (or is it recordedmarkup?) in the DB for the
>> recording in question.
>>
>>
> Running the repair table tool in PHPMyAdmin also fixes this  
> problem :-)
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ourshack.com/pipermail/mythtvnz/attachments/20080904/e923d51d/attachment.htm