matt.poff at headfirst
Sep 3, 2008, 5:01 PM
Post #4 of 4
(370 views)
Permalink
|
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/
|
