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

[Craig Huff]

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?

TIA

Craig.