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

Lost Recording info after upgrade
http://forums.linhes.org/viewtopic.php?f=5&t=16356
Page 1 of 1

Author:  branmu [ Fri Sep 07, 2007 9:58 pm ]
Post subject:  Lost Recording info after upgrade

I upgraded for the first time. I had the same install for about 1.5 years. After I finished upgrading I was having a problem with the backend not starting. So I redid the autoupgrade, but before I did I backedup again while the backend was not working. Now I fixed my backend problem, but my recording information is gone. Is it because I backedup while the backend was not working or is there some way to fix it?

Author:  cecil [ Fri Sep 07, 2007 10:02 pm ]
Post subject: 

Something else must be wrong. If you backed up and something goes a miss, you can restart the auto upgrade w/o backing up again. Are the backup files in /myth/backup?

Author:  branmu [ Fri Sep 07, 2007 11:32 pm ]
Post subject: 

There are several files in the /myth/backup directory:

mythconverg.sql.bz2.1
mythconverg.sql.bz2.2
mythconverg.sql.bz2.3
mythconverg.sql.bz2.4
mythconverg.sql.bz2.5
mythconverg.sql.bz2.6
mythconverg.sql.bz2.7
mythconverg.sql.bz2.8
mythconverg.sql.bz2.9
myconverg.sql.gz
myconverg.sql.gz1
savedfiles.tar.bz2.1
savedfiles.tar.bz2.2
savedfiles.tar.bz2.3
savedfiles.tar.bz2.4
savedfiles.tar.bz2.5
savedfiles.tar.bz2.6
savedfiles.tar.bz2.7
savedfiles.tar.bz2.8
savedfiles.tar.bz2.9
savedfiles.tar.gz

Any ideas?

Author:  tjc [ Sat Sep 08, 2007 8:11 am ]
Post subject: 

Date stamps on those files? Actual output from
Code:
ls -al /myth/backup/

would be preferred.

Author:  branmu [ Sat Sep 08, 2007 9:50 am ]
Post subject: 

Here is the output:

Code:
total 324992
drwxrwxr-x  2 mythtv mythtv     4096 Sep  7 19:26 .
drwxr-xr-x 24 root   root       4096 Sep  7 18:01 ..
-rw-------  1 root   root   14211304 Sep 25  2006 mythconverg.sql.bz2.1
-rw-------  1 root   root    4400569 Jul  5 20:15 mythconverg.sql.bz2.2
-rw-------  1 root   root    4952666 Apr  5 20:15 mythconverg.sql.bz2.3
-rw-------  1 root   root    4875277 Dec 20  2006 mythconverg.sql.bz2.4
-rw-------  1 root   root    4632245 Dec 10  2006 mythconverg.sql.bz2.5
-rw-------  1 root   root    4700273 Nov 30  2006 mythconverg.sql.bz2.6
-rw-------  1 root   root    2558554 Nov 14  2006 mythconverg.sql.bz2.7
-rw-------  1 root   root     569527 Nov  4  2006 mythconverg.sql.bz2.8
-rw-------  1 root   root    2169741 Nov  3  2006 mythconverg.sql.bz2.9
-rw-------  1 root   root      18551 Sep  7 19:25 mythconverg.sql.gz
-rw-------  1 root   root    7468961 Sep  7 14:36 mythconverg.sql.gz.1
-rw-------  1 root   root   81771120 Sep  7 14:42 savedfiles.tar.bz2.1
-rw-------  1 root   root    8341107 Jul  5 20:16 savedfiles.tar.bz2.2
-rw-------  1 root   root   19977568 Apr  5 20:17 savedfiles.tar.bz2.3
-rw-------  1 root   root   14187422 Dec 20  2006 savedfiles.tar.bz2.4
-rw-------  1 root   root   14219336 Dec 10  2006 savedfiles.tar.bz2.5
-rw-------  1 root   root   14203755 Nov 30  2006 savedfiles.tar.bz2.6
-rw-------  1 root   root   14219595 Nov 14  2006 savedfiles.tar.bz2.7
-rw-------  1 root   root   14196122 Nov  4  2006 savedfiles.tar.bz2.8
-rw-------  1 root   root   14211614 Nov  3  2006 savedfiles.tar.bz2.9
-rw-------  1 root   root   86415937 Sep  7 19:25 savedfiles.tar.gz


Author:  tjc [ Sat Sep 08, 2007 10:25 am ]
Post subject: 

branmu wrote:
-rw------- 1 root root 18551 Sep 7 19:25 mythconverg.sql.gz
-rw------- 1 root root 7468961 Sep 7 14:36 mythconverg.sql.gz.1

Your DB backup looks truncated. As root, try moving mythconverg.sql.gz.1 to mythconverg.sql.gz and restoring...
Code:
mv /myth/backup/mythconverg.sql.gz.1 /myth/backup/mythconverg.sql.gz
mythrestore

BTW - This is probably a result of the issue covered under Know Changes 1.2 and Phase 0 step 1.3 in the R5F1 Hints...

Author:  branmu [ Sat Sep 08, 2007 11:16 am ]
Post subject: 

That worked to get the database listings back, but now every recording says "The file for this recording cannot be found". It seem to be every recording from oldest to newest. My /myth/tv is filled with the .mpg and mpg.png files for the recordings. Any ideas?

Author:  tjc [ Sat Sep 08, 2007 11:37 am ]
Post subject: 

You didn't accidentally change your hostname did you? That can cause all kinds of screwy problems. What does this show on your box?
Code:
root@black2:~# hostname
black2
root@black2:~# mysql mythconverg -e "select * from settings where value='RecordFilePrefix'"
+------------------+----------+----------+
| value            | data     | hostname |
+------------------+----------+----------+
| RecordFilePrefix | /myth/tv | black2   |
+------------------+----------+----------+

Author:  branmu [ Sat Sep 08, 2007 11:55 am ]
Post subject: 

The data field said /mnt/store, so I changed it in the setup to /myth/tv and that solved it. Awsome help! Thank you so much!

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