<div class="gmail_quote">2012/5/31 Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 05/31/2012 01:33 AM, Thomas Pontoppidan wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
2012/5/30 Michael T. Dean<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
On 05/30/2012 03:03 AM, Thomas Pontoppidan wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
2012/5/29 Michael T. Dean<br>
<br>
On 05/29/2012 03:36 AM, Thomas Pontoppidan wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
During this weekend I finally chose to reinstall my backend - moving<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
During this weekend I finally chose to reinstall my backend - moving from<br>
an old Fedora install to MythBuntu. For different reasons I decided to<br>
go<br>
against recommendations and not move the entire database. I only<br>
transferred my recordings following this guide<br>
</div><a href="http://www.mythpvr.com/mythtv/**tips/migrate-recordings.html" target="_blank">http://www.mythpvr.com/mythtv/<u></u>**tips/migrate-recordings.html</a><br>
.<br>
</blockquote><div class="im">
Yes. Google should be kicked off the Internet for allowing that<br>
ancient,<br>
outdated, incorrect, can-corrupt-the-db-data (as it can completely break<br>
your character encoding) post to be #1.<br>
<br>
</div></blockquote><div class="im">
Well, I won't blame Google - after all it was my decision to not follow<br>
official directions:-)<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
From a normal frontend the recordings are playing fine, but HLS doesn't<br>
seem to work - I try to stream to Torc for IOS, but the "prepare stream"<br>
stays at 0%. If I make a new recording it streams fine so I'm guessing<br>
some<br>
new fields in the recordings table are missing? Is there any way to add<br>
the<br>
missing info (if my assumption is correct) to the database?<br>
</blockquote>
Best solution is to do a proper restore of your complete pre-upgrade<br>
database and let MythTV Do The Right Thing.<br>
</blockquote>
Looking back that is probably what I *should* have done, but I am not<br>
sure<br>
I'm up for that now - I spent most of a day setting up the new database,<br>
mostly because I wasn't satisfied with the old setup (non-standard<br>
keybindings,<br>
<br>
</div></blockquote><div class="im">
can be reset to defaults by going into mythfrontend Utilities/Setup|Edit<br>
Keys, then using MENU to select "Reset All Keys to Defaults" (<br>
</div><a href="http://www.gossamer-threads." target="_blank">http://www.gossamer-threads.</a>**<u></u>com/lists/mythtv/commits/**<u></u>487153#487153<<a href="http://www.gossamer-threads.com/lists/mythtv/commits/487153#487153" target="_blank">http://www.<u></u>gossamer-threads.com/lists/<u></u>mythtv/commits/487153#487153</a>>) on any frontend whose key bindings you want to reset.<div>
<div class="h5"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
bad tuner setup,<br>
<br>
</blockquote>
which could have been reset/cleared by using mythtv-setup to do a "Delete<br>
all capture cards"<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
flawed channel lists etc.).<br>
<br>
</blockquote>
and a "Delete all video sources" (not "Delete all video sources on<br>
<hostname>").<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Going back would<br>
require me to do it all over again:-)<br>
<br>
</blockquote>
But would make the rest of your system function properly--and without any<br>
concerns over the integrity of your database schema or data.<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
If you decide you want to waste hours re-configuring everything for no<br>
benefit, at least do a proper partial restore:<br>
<a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup" target="_blank">http://www.mythtv.org/wiki/<u></u>Database_Backup_and_Restore#<u></u>Partial_restore_of_a_backup</a> (and take note of<br>
<a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_when_upgrading_MythTV" target="_blank">http://www.mythtv.org/wiki/<u></u>Database_Backup_and_Restore#<u></u>Partial_restore_when_<u></u>upgrading_MythTV</a><br>
).<br>
</blockquote>
I already did reconfigure the entire setup and according to the links I<br>
would need to do some preparation on the old setup - obviously not<br>
possible<br>
now that the system is already upgraded:-(<br>
<br>
Guess I will have a closer look at the tables while I consider the<br>
"complete restore" option:-(<br>
<br>
</blockquote>
Right, I'm suggesting you either do a full restore--and then use MythTV<br>
tools to clean up what you don't like--or start over with a supported<br>
partial restore. I can't guarantee that HLS would work with your old<br>
recordings if you do the partial restore using the restore script, but at<br>
that point, I'd be motivated to help debug the issues, since I wouldn't<br>
have any reason to assume your DB is corrupt.<br>
</div></div></blockquote><div><div class="h5">
<br>
Thanks for your input - I will definitely use the proper procedure next<br>
time! But this time I just can't imagine starting over after all the work<br>
I've done:-)<br>
<br>
Anyway, problem seems to be solved: I found a difference in paths in the<br>
"livestream" table during HLS streaming - for new recordings it pointed to<br>
the recording's real location while the old recording entry would point to<br>
"myth:@"host-from-the-old-<u></u>setup"/"file". After updating the hostname in the<br>
recordings table and restarting mythbackend streaming works fine!<br>
</div></div></blockquote>
<br>
Meaning you changed your host name and didn't update your MythTV setup:<br>
<br>
<a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend" target="_blank">http://www.mythtv.org/wiki/<u></u>Database_Backup_and_Restore#<u></u>Change_the_hostname_of_a_<u></u>MythTV_frontend_or_backend</a><br>
<br>
If you're comfortable believing that everything else--data and schema--in your current DB is good and there's no other brokenness (other than the loss of non-re-creatable information due to the broken procedure you followed for the partial restore) and/or that you can figure out and fix all the problems that crop up in the future (and you believe that doing so will take less time than doing a full restore of the pre-upgrade DB backup, changing hostname (as above), Delete All Capture Cards, Delete All Video Sources, creating new cards and video sources, connecting inputs, and scanning channels, then resetting key bindings in mythfrontend...), I suppose I'm comfortable letting you run with your not-as-good-as-it-should-be database. :) (Just saying that you won't have the option to go back to your pre-upgrade database backup for long, so now is the only opportunity...)<br>
</blockquote><div><br></div><div>I am comfortable believing that everything besides the migrated data is good - after all, everything else is configured from scratch and the old recordings will eventually be deleted.</div>
<div><br></div><div>I do get you subtle hint, but under the circumstances I would rather run with my not-as-godd-as-it-should-be database than develop a not-as-good-as-it-should-be relationship with my better half by spending more time on the upgrade;-)</div>
<div><br></div><div>Thanks again!</div></div>