<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Jan 3, 2018, at 4:28 PM, Scot Kreienkamp <<a href="mailto:skreien@wcnet.org" class="">skreien@wcnet.org</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Any idea what the transcoded column in the recorded table is for, or what happens if that's modified to a non-zero value? </div></div></blockquote><div><br class=""></div><div><br class=""></div>I don’t know. I have not had to modify it. I recall finding the update statement in an older shell posted on the mythtv wiki. I did have to modify the statement when I upgraded to v.28.</div><div><br class=""></div><div><br class=""></div><div>I ‘cheated’ with regards to the location of the recordings, since I only use one location. If you use multiple locations in your setup, things will need to change.</div><div><br class=""></div><div>I also had to start using —login-path-local when mysql was upgraded. google will help you with it.</div><div><br class=""></div><div>Regards,</div><div><br class=""><blockquote type="cite" class=""><div class=""><div class="gmail_extra"><br class=""><div class="gmail_quote">On Wed, Jan 3, 2018 at 4:10 PM, Scot Kreienkamp <span dir="ltr" class=""><<a href="mailto:skreien@wcnet.org" target="_blank" class="">skreien@wcnet.org</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class="">From your script, I basically just update the DB with the new information and clear out any existing information from the recordedmarkup and recordedseek table, which also means I would have to manage the mpg file by hand as it would no longer be registered in Myth. <div class=""><br class=""></div><div class="">Got it, thanks!</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br class=""><div class="gmail_quote">On Wed, Jan 3, 2018 at 10:34 AM, jrh <span dir="ltr" class=""><<a href="mailto:jharbestonus@gmail.com" target="_blank" class="">jharbestonus@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I have been using the following for creating a compressed mp4 and replacing the mpg or ts file with the compressed file.<br class="">
<br class="">
It does need a couple tweaks for current 29 version. The changes I made are at the beginning where it detects whether the file is an mpg or nuv or mp4. I just added another section in it to tweak for ts files.<br class="">
<br class="">
You may also need to tweak the mysql cmd line to change how it deals with username/password.<br class="">
<br class="">
<a href="https://www.mythtv.org/wiki/Transcodehb.sh" rel="noreferrer" target="_blank" class="">https://www.mythtv.org/wiki/Tr<wbr class="">anscodehb.sh</a><br class="">
<br class="">
<br class="">
Regards<br class="">
<div class=""><div class="m_-2924585040950747697h5"><br class="">
> On Jan 2, 2018, at 11:14 PM, Scot Kreienkamp <<a href="mailto:skreien@wcnet.org" target="_blank" class="">skreien@wcnet.org</a>> wrote:<br class="">
><br class="">
> Hi everyone...<br class="">
><br class="">
> I have transcodes working great on 29, now I'm thinking about replacing the original with the transcoded version. I have two questions that the wiki isn't clear on... Is there anything I need to do with the database to make mythtv find the new transcoded file, and will mythtv still manage the original file or do I need to do it myself or delete the original?<br class="">
><br class="">
> Thanks!<br class="">
><br class="">
><br class="">
</div></div>> ______________________________<wbr class="">_________________<br class="">
> mythtv-users mailing list<br class="">
> <a href="mailto:mythtv-users@mythtv.org" target="_blank" class="">mythtv-users@mythtv.org</a><br class="">
> <a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank" class="">http://lists.mythtv.org/mailma<wbr class="">n/listinfo/mythtv-users</a><br class="">
> <a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank" class="">http://wiki.mythtv.org/Mailing<wbr class="">_List_etiquette</a><br class="">
> MythTV Forums: <a href="https://forum.mythtv.org/" rel="noreferrer" target="_blank" class="">https://forum.mythtv.org</a><br class="">
<br class="">
______________________________<wbr class="">_________________<br class="">
mythtv-users mailing list<br class="">
<a href="mailto:mythtv-users@mythtv.org" target="_blank" class="">mythtv-users@mythtv.org</a><br class="">
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank" class="">http://lists.mythtv.org/mailma<wbr class="">n/listinfo/mythtv-users</a><br class="">
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank" class="">http://wiki.mythtv.org/Mailing<wbr class="">_List_etiquette</a><br class="">
MythTV Forums: <a href="https://forum.mythtv.org/" rel="noreferrer" target="_blank" class="">https://forum.mythtv.org</a><br class="">
</blockquote></div><br class=""></div>
</div></div></blockquote></div><br class=""></div>
_______________________________________________<br class="">mythtv-users mailing list<br class=""><a href="mailto:mythtv-users@mythtv.org" class="">mythtv-users@mythtv.org</a><br class="">http://lists.mythtv.org/mailman/listinfo/mythtv-users<br class="">http://wiki.mythtv.org/Mailing_List_etiquette<br class="">MythTV Forums: https://forum.mythtv.org<br class=""></div></blockquote></div><br class=""></body></html>