[mythtv-users] Need sanity check re: repairing seektable and commflagging

[Michael T. Dean]

On 05/13/2009 11:32 AM, Craig Huff wrote:
> Seems I shoulda been checking the size of the /var partition!  Ran out
> of space and mySQL crashed.  Last night's recordings consequently
> don't have any seektable data.  I got /var down from 100% by cleaning
> up the logs that had filled it up and their cause for running away and
> then got a clean run of optimize_mythdb.pl.
>
> After reading wiki pages and e-mail archives it appears that my next steps are:
>
> $ for file in "list of last night recording filenames" ;
> do
>   mythtranscode --mpeg2 --buildindex --allkeys --showprogress --infile $file
>   mythcommflag --file $file
> done
>
> Or, alternately take the mythcommflag command out of the do-loop and
> use this after the do-loop:
> $ mythcommflag --allstart 20090512130000  #for everything recorded
> after 1pm yesterday
>
> Is this correct?  Complete?  Or do I need to do something more/different?

Make sure you've run optimize_mythdb.pl first.  Then, build seektables 
for any new recordings.  The mythcommflag approach won't work for MPEG-2 
(unless you're running trunk), so you'll probably need to do the 
mythtranscode approach.

Mike