LinHES Forums
http://forums.linhes.org/

Import recordings from old R5F27 into new R6?
http://forums.linhes.org/viewtopic.php?f=25&t=20664
Page 1 of 1

Author:  davej45 [ Thu Dec 10, 2009 8:05 am ]
Post subject:  Import recordings from old R5F27 into new R6?

Upgrading my trusty Knoppmyth system from R5F27 to the new LinHES R6 version was problematic, so I ultimately decided on a completely fresh install instead, which, other than endless fuppes error messages, which I am still trying to figure out, everything else seems to work as expected. What is fuppes, why do I need it, and can I just delete it to make these errors go away? All questions I am trying to find answers to.

More Importantly, and the central point of this inquiry:

I had made a backup copy of my old system's /myth partition, currently mounted as /myth3, and I am wondering if there is a script or some other way to easily incorporate those recording files into the new R6 database?

As I recall, once in the past, there was a script for Knoppmyth that would recover 'orphan' files and place them in the database. How would I do a similar proceedure in R6?

Thanks in advance for any advice. I thought I was pretty comfortable with LINUX and Knoppmyth, but quite frankly, Arch and LinHES is creating an unexpectedly high learning curve in my immediate vicinity!
Not complaining mind you, I know that as soon as MY abilities are up to the task, the new system will be even better than the Knoppmyth system I have used and loved for so many years!

Author:  graysky [ Thu Dec 10, 2009 1:50 pm ]
Post subject: 

Hmmm... steps I would try assuming you did a mythbackup before the upgrade:

1) Do the fresh install of R6 to the new hdd (which you did)
2) Manually copy over all of your old /myth partition to the new hdd's /myth (your myth3 I guess) using gparted or rsync or cp -a ..whatever
3) Boot from the R6 CD and select upgrade to install ontop of your modified R6 install. The installer should catch your backups and restore/upgrade them

I dunno about any script based method.

Author:  goofee [ Thu Dec 10, 2009 3:06 pm ]
Post subject: 

I think the script your looking for is
Code:
 /usr/share/mythtv/contrib/myth.find_orphans.pl
but if you have a lot of recordings that will take some time. You might be able to get program information from /myth/pretty if it still exists.

If you have a proper backup, you could extract the tables from it and restore only the ones you need into the DB. You need the following.
Quote:
oldrecorded
people (referenced by recordedcredits)
recorded
recordedcredits
recordedmarkup
recordedprogram
recordedrating
recordedseek



Check out http://mysettopbox.tv/phpBB2/viewtopic.php?t=17867

Edit: just realized your useing R5F27. I think F27 had mythtv.20.2 but R5.5and R6 have mythtv.21. It may not be a good idea to import only the DB data you needs as some DB structures have changed.

Author:  goofee [ Thu Dec 10, 2009 4:52 pm ]
Post subject: 

Sorry, wrong one. That one finds but doesn't import. Try this one.
Code:
 /usr/share/mythtv/contrib/myth.rebuilddatabase.pl

Author:  tjc [ Fri Dec 11, 2009 7:42 pm ]
Post subject: 

As goofee suggested selectively restoring the data from the correct tables is probably the best way to go. Memory says that someone actually wrote and posted a script to pull the necessary records out of the backup after I researched the tables for them...

This looks like one of the relevant threads: http://knoppmyth.net/phpBB2/viewtopic.php?t=17867

Author:  JoeF [ Sat Oct 02, 2010 7:47 pm ]
Post subject: 

goofee wrote:
Sorry, wrong one. That one finds but doesn't import. Try this one.
Code:
 /usr/share/mythtv/contrib/myth.rebuilddatabase.pl

Now at
Code:
/usr/share/mythtv/contrib/recovery/myth.rebuilddatabase.pl

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/