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

Upgrade Woes: Missing TV content
http://forum.linhes.org/viewtopic.php?f=6&t=7403		 Page 1 of 1
Author:  scorp1us [ Fri Dec 16, 2005 9:50 am ]
Post subject:  Upgrade Woes: Missing TV content
I did a auto upgrade from a16 to a26. After fixing my fstab (i use several drives) all the TV content (which was not on HDA) is gone. I did a myth backup before hand, and that seemed to go well.

How can I resurect my tv recordings? I got my movies back, but no recordings (they were on the same drive)

Also, what facility is used to play TV recordings? It works, but I can;t watch movies on the other Myth box, even though I have exported and mounted my my media folder.

Thanks!
Author:  tjc [ Fri Dec 16, 2005 8:30 pm ]
Post subject: 
Did you fix the mount points (and possibly links) up so that /myth/tv is where the files really are?
Author:  scorp1us [ Tue Dec 20, 2005 8:25 pm ]
Post subject: 
The files are in /myth/tv
/myth/tv is mounted again (it was as of my pervious email)
Nothing shows up.

One question I have is is /myth safe to export to all front ends?

I have 2 boxes (a backend and a front end) and I use a front end on the backend as well, mainly for testing. /myth is exported by the backend to the front end.
Author:  tjc [ Tue Dec 20, 2005 9:12 pm ]
Post subject: 
OK, lets see if we have this straight:

1) You did a backup before upgrading? Let's check to see if anything is there. Run this command and post the results:
Code:
ls -al /myth/backup


2) After the upgrade you've got a /myth/tv directory which still has .nuv files in it? Do this command and post the results:
Code:
ls /myth/tv/*.nuv /myth/tv/*.mpg | wc -l


3) If there is a non-empty backup in /myth/backup did it get restored properly? Do this command to check for entries in the recordings table:
Code:
mysql mythconverg -e "select count(*) from recorded"


The numbers from steps 2 and 3 should match. If they don't you probably have some orphans either because the backup failed or the restore did.
Author:  scorp1us [ Thu Dec 29, 2005 4:36 pm ]
Post subject: 
1)
@mythtv:~$ ls -al /myth/backup
total 26112
drwxr-xr-x 2 mythtv mythtv 4096 Dec 2 01:06 .
drwxr-xr-x 14 root root 4096 Nov 25 15:00 ..
-rw-r--r-- 1 mythtv mythtv 9236480 Dec 2 01:04 etc.tar.bak
-rw-r--r-- 1 root root 53 Dec 2 01:06 etc.tar.gz
-rw-r--r-- 1 mythtv mythtv 10240 Dec 2 01:04 home.tar.bak
-rw-r--r-- 1 root root 54 Dec 2 01:06 home.tar.gz
-rw-r--r-- 1 root root 6447430 Dec 2 01:06 mythconverg.sql
-rw-r--r-- 1 mythtv mythtv 6447430 Dec 2 01:04 mythconverg.sql.bak
-rw-r--r-- 1 mythtv mythtv 3714907 Dec 2 01:06 mythtv.tar.bz2
-rwxr----- 1 root root 45 Dec 2 01:06 root.tgz
-rw-r--r-- 1 mythtv mythtv 802816 Dec 2 01:04 root.tgz.bak


2)
26

3)
0


So how do I repopulate the database?

I noticed that the mysql acess changed... I don't remember A16 requiring a password, btu it seems like A26 does. Could it be that?


Thanks for all your help!
Author:  tjc [ Thu Dec 29, 2005 11:21 pm ]
Post subject: 
Hmm... I'm running a funky version so maybe the DB table for recordings has chnaged. Hang on while I boot the test system and check ... Nope thats got the same tables... Just for the heck of it try that second query on recordedprogram instead of recorded

OBTW - On the mysql access, I was ruuning the commands as root, while you're running threm as the mythtv user.
Author:  scorp1us [ Fri Dec 30, 2005 8:32 pm ]
Post subject: 
recordedprogram: still 0
Author:  tjc [ Fri Dec 30, 2005 8:40 pm ]
Post subject: 
How about this?
Code:
grep -i '`recorded`' /myth/backup/mythconverg.sql | wc -l

If you get a zero, your backup was roached to begin with.
Author:  scorp1us [ Fri Dec 30, 2005 9:40 pm ]
Post subject: 
28
Author:  tjc [ Sat Dec 31, 2005 1:03 am ]
Post subject: 
OK, so strip off the "wc -l" and add a mysql command to read and execute those insert statements. You may actually want to look at what the /usr/local/bin/mythrestore script is doing with that file.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/