I've found that running the following SQL command:<div><br></div><div>Update recorded set watched=1 where watched=0</div><div><br></div><div>Updates all the currently recorded shows and marks them as watched. Now when auto-expire happens due to disk space, it marks the show as a duplicate and never tries to record it again.</div>
<div><br></div><div>This approach was much simpler than trying to purge the files, etc and has been working great for me since I already had automated processes in place to rename the files using MythLink.pl (user job) and then to copy off the friendly video file names (using a scheduled task on a Windows box) and do all the processing and archiving. :-)</div>
<div><br></div><div>Hopefully this final recap helps others with the same need in the future.</div><div><br clear="all"><div><div>Jason</div></div>
<br><br><div class="gmail_quote">On Sun, Mar 17, 2013 at 6:17 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On 03/17/2013 07:15 PM, Michael T. Dean wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Exactly. This would be the best approach. Note, also, that you don't even need the script to rename the videos--just copy the symlink created by MythTV while dereferencing and you'll create a file on the new system with the same name as the link, but the content of the file.<br>
</blockquote>
<br></div>
er, "copy the symlink created by <a href="http://mythlink.pl" target="_blank">mythlink.pl</a>"<div class="HOEnZb"><div class="h5"><br>
<br>
Mike<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/<u></u>listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br></div>