<p>Thanks, Mike. I missed the MPEG2 part of that wiki entry. </p>
<p>The odd thing is that my rebuild did *something* - the shows that were unwatchable before are at least watchable now. </p>
<p><blockquote type="cite">On Oct 14, 2009 11:55 AM, "Michael T. Dean" <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<br><br><p><font color="#500050">On 10/14/2009 08:43 AM, Phil Bridges wrote:
>
> Sunday, my database borked up royally - enough to ca...</font></p>
--all does not work for seektable rebuilds (at least not in 0.21-fixes; it's "supposed to" in trunk, but I've never tested). So, you actually just scanned for commercials on every single recording.<br>
<br>
Also, in 0.21-fixes, mythcommflag --rebuild does not work for (nearly all) MPEG-2. You need to use mythtranscode --buildindex.<br>
<br>
You need to run the command on every single recording individually. Note, also, that --queue does not work with --rebuild. Therefore, run a script...<br>
<br>
<a href="http://www.mythtv.org/wiki/Repairing_the_Seektable" target="_blank">http://www.mythtv.org/wiki/Repairing_the_Seektable</a><br>
<br>
cd /path/to/first/recordings/directory<br>
for file in *; do<br>
mythtranscode --mpeg2 --buildindex --allkeys \<br>
--showprogress --infile $file<br>
done<br>
cd /path/to/next/recordings/directory<br>
<br>
(and so on)<br>
<br>
And, far more importantly:<br>
<a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore" target="_blank">http://www.mythtv.org/wiki/Database_Backup_and_Restore</a><br>
<br>
Mike<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</blockquote></p>