<div dir="ltr">On Mon, Oct 7, 2013 at 1:24 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 10/06/2013 03:10 PM, Monkey Pet wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Sat, Oct 5, 2013 at 10:34 PM, Monkey Pet wrote:<div class="im"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Wed, Oct 2, 2013 at 7:33 PM, Monkey Pet wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Running mythtv 0.26.x, I scan for channels, it says it found some, but<br>
refuses to add them. I am not sure what I am doing wrong. I am in the US<br>
and using broadcast. I have tried deleting and re-adding the capture cards<br>
(HD homerun) and also input sources. I tried all to delete all the<br>
channels. My HD homerun is connected to a UHF antenna.<br>
<br>
</blockquote>
I also tried with mythtv 0.27 same issue. I am thinking something is<br>
goofy about my db. I dropped by db, then started a new one from scratch,<br>
the scan and channel add went through fine. Can someone suggest which<br>
additional tables I need to delete or clear to make the channel add work?<br>
Like I said in my previous post, i deleted through mythtv-setup all<br>
capture cards, video sources, input connections. Mythtv finds the channel<br>
and pretends like it is adding it, but it doesn't.<br>
<br>
</blockquote>
I ended up starting with a new database, then doing a partial restore of<br>
the database to bring over my recordings, scanning for the new channels<br>
worked, my recordings are still there!<br>
<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><br>
<br>
</div></blockquote>
<br>
FWIW, there is /absolutely/ no difference between starting with a new database and using an old database with old capture card/video source/input/channel configuration that's been "cleared" with "Delete all video sources" and "Delete all capture cards" (not "Delete all capture cards from <hostname>"). The /only/ way a new database would be different is if your database schema were corrupt in some way (which can happen in any of a number of ways, including restoring a database backup that wasn't created properly). That said, if you did have a corrupt schema, the partial restore is the proper way to fix it (and, really, that's the only useful purpose of a partial restore).<br>
<br>
Glad you got it working, though. And, even if you just needed to do the "Delete all video sources" and/or "Delete all capture cards" to make things work with the old database, the process you described would work, too, and the only down side is all the extra work you had to do to reconfigure every single backend and frontend system and re-create data for all your plugins (rescan for videos/music/... and re-grab/-fix metadata and ...). So at this point, you've paid the price for the partial restore, and you might as well stick with the database you have, now. (In other words, I'm not recommending you go back and do it the other way, but trying to ensure that anyone else who sees this thread in the archives knows that there was probably a much easier approach than nuking the database from orbit.)<br>
</blockquote><div><br></div><div>Thanks Michael for the response and specifically this useful info to the thread.</div><div><br></div><div>My database was probably messed up in weird and mysterious ways. My mythtv setup went through a bunch of crazy stuff like power supply blowing, drive filling up, drive having bad sectors, multiple fedora upgrades, motherboard swaps, and probably stuff I don't even remember. My oldest recording is dated 2005 and I have been lucky that the database kept churning along until the latest chanscan incident. Hopefully won't need to do this again for another 10 years :) </div>
<div><br></div><div>Still a very happy mythtv user, my family is surprised when they see commercials.</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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>
</blockquote></div><br></div></div>