View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 9 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri Sep 07, 2007 9:58 pm 
Offline
Joined: Fri Nov 03, 2006 9:17 pm
Posts: 6
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?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 07, 2007 10:02 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
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?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 07, 2007 11:32 pm 
Offline
Joined: Fri Nov 03, 2006 9:17 pm
Posts: 6
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?


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 08, 2007 8:11 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Date stamps on those files? Actual output from
Code:
ls -al /myth/backup/

would be preferred.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 08, 2007 9:50 am 
Offline
Joined: Fri Nov 03, 2006 9:17 pm
Posts: 6
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



Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 08, 2007 10:25 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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...


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 08, 2007 11:16 am 
Offline
Joined: Fri Nov 03, 2006 9:17 pm
Posts: 6
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?


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 08, 2007 11:37 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
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   |
+------------------+----------+----------+


Top
 Profile  
 
 Post subject:
PostPosted: Sat Sep 08, 2007 11:55 am 
Offline
Joined: Fri Nov 03, 2006 9:17 pm
Posts: 6
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!


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 28 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu