[mythtv-users] Regenerate recordedmarkup?

[dave sailer]

Ant Daniel wrote:

>On 18/11/05, E Norm <enorm1 at gmail.com> wrote:
>  
>
>>I got one recording that has, for whatever reason, been corrupted in the
>>recordedmarkup table.
>>It is not possible to use the forward or rewind buttons on the show but
>>to just play it works fine.
>>
>>Is there a way to re-generate that info?
>>
>>/Eric
>>_______________________________________________
>>mythtv-users mailing list
>>mythtv-users at mythtv.org
>>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>>    
>>
>
>mythcommflag --rebuild
>
>You can specify other params here i.e. chanid, starttime, endtime,
>etc, I use -f file --force.
>
>I have found that it desn't always work for me if there are still
>records for this in the recordedmarkup table, so I usually delete them
>'DELETE FROM recordedmarkup WHERE chanid = <channel> AND
>starttime="yyyy-mm-dd hh:mm"'
>
>Note: if you do a select first the result could be large and for me it
>can crash my link, if I want to check I do the Select with a SUM(*)
>instead.
>
>All this from memory so check with mythcommflag --help and check that
>I got the column names correct (show columns from recordedmarkup)
>
>Ant.
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>  
>
I find the mysql db gets corrupted sometimes. Whenever something odd 
starts happening with myth I usually try this first..

mysqlcheck mythconverg recordedmarkup -u username -p -r

you can leave the table name off and it will check all tables.