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!

Did you fix the mount points (and possibly links) up so that /myth/tv is where the files really are?

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.

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:

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:

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:

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.

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!

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.

recordedprogram: still 0

How about this?

If you get a zero, your backup was roached to begin with.

28

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.