View unanswered posts    View active topics

Board index KnoppMyth General

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
tjc
PostPosted: Wed Dec 27, 2006 11:08 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
RichardBronosky wrote:
tjc wrote:
Send me the results of "ls -al /myth/backup" on you box. I'm guessing that it's empty. What version are you upgrading from? Did you have an LVM partition that you forgot to recreate?

I was cautious to make sure that not only were the backups there, but also used "tar -tvf" to verify that my custom configs were included. I also made sure the the sql file seemed to have all the info for the recordedprogram table. I am also on a single disk, so I don't think I'm using LVM. (This system started with an r5a~15 auto install.) As far as my old version goes, I think it was R5B7. Definitely not R5D1, and I think I recall that C7 came out the day after I upgraded from a~30, so I never upgraded again. As for the listing, here you go: (I have some personal backups in there too, but the Dec 26 stuff is from KnoppMyth>Backup)
Code:
-rw-r--r-- 1 mythtv mythtv   854427 Apr 17  2006 2004-2005 Bronosky R Tax Return.zip
-rw-r--r-- 1 mythtv mythtv 35967122 Jul 16 19:10 Art-Work.zip
-rw-r--r-- 1 mythtv mythtv  4563431 Jul 17 20:01 Cleaned Heartbeat Looped_data.zip
-rw-r--r-- 1 mythtv mythtv   307200 Dec 26 21:44 etc.tar
-rwxr-xr-x 1 mythtv mythtv     4246 Nov 27 19:37 getKnoppMyth.sh
-rw-r--r-- 1 mythtv mythtv 37683200 Dec 26 21:44 home.tar
-rw-r--r-- 1 mythtv mythtv 84389930 Dec 26 21:44 mythconverg.sql
-rw-r--r-- 1 mythtv mythtv 19526319 Dec 26 21:44 mythtv.tar.bz2
-rwxr----- 1 mythtv mythtv   504635 Dec 26 21:44 root.tgz

tjc wrote:
The missing mythrestore.old is something that I thought was fixed, but apparently not.

So, should that .old script "not be called", or "not be missing"? Is that .old script what I need to upgrade from an R5B7?

For what it is worth, I entered sudo mysql and did:
Code:
use mythconverg;
show tables;
#looked good
select * from recordedprogram;
# Empty set
# In another screen session I did 'grep recordedprogram /myth/backup/mythconverg.sql>/tmp/recordedprogram.sql'
source /tmp/recordedprogram.sql;
# at this point I realize that my grep included the line 'CREATE TABLE `recordedprogram` (' which, since it didn't have a semicolon, became part of the first insert statement causing that one insert to fail.  that was no big deal, the rest of the records got in there okay.
select * from recordedprogram;
# all seemed to look good.
quit
# sudo /etc/init.d/mythtv-backend stop; sudo /etc/init.d/mythtv-backend restart

After a frontend restart, I still had no recorded programs listed. So, to minimize the risk of breaking it further, I emptied the table and decided to wait for advice.

We can get you a modern backup out of that. All we need is a moderate sized chunk of free disk space to play Dr. Frankenstein in.


Last edited by tjc on Wed Dec 27, 2006 11:33 pm, edited 1 time in total.
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Wed Dec 27, 2006 11:28 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
The script should be there. It's part of the normal fall back logic. I suspect it got cleaned up because the name made it look like a backup file...

1) Decompress all the tar files:
Code:
cd /myth/backup/
bzip2 -d mythtv.tar.bz2
gzip -d root.tgz


2) Copy one of the files to savedfiles.tar:
Code:
cp root.tar savedfiles.tar


3) Append the remaining tar files in this order:
Code:
tar -Af savedfiles.tar home.tar
tar -Af savedfiles.tar etc.tar
tar -Af savedfiles.tar mythtv.tar


4) (Optional) recompress everything:
Code:
gzip *.tar mythconverg.sql


At this point you should be able to run the mythrestore script and have it work.

BTW - While you're looking at those check that the path names in all the tarfiles start with '"./". The restore may not extract stuff that doesn't, which will mean playing another game before this is really ready to use. Sorry... :oops:

Edited to do the tar archive merge stepwise... R - could you post a summary of how you did the fix up for the leading "./" Thanks...


Last edited by tjc on Wed Dec 27, 2006 3:16 pm, edited 2 times in total.
Top
 Profile  
 
RichardBronosky
 Post subject:
PostPosted: Wed Dec 27, 2006 12:06 pm 
Offline
Joined: Tue Aug 16, 2005 11:50 am
Posts: 181
Location: Douglasville, GA
tjc wrote:
BTW - While you're looking at those check that the path names in all the tarfiles start with '"./". The restore may not extract stuff that doesn't, which will mean playing another game before this is really ready to use. Sorry... :oops:


Yes, they do start with a dot, so I've been adding "-C /" to all my tar -x commands to make sure they don't end up in a whole new hierarchy in my $PWD

I'll try your archive rebuild steps and let you know how it goes.
Top
 Profile  
 
RichardBronosky
 Post subject:
PostPosted: Wed Dec 27, 2006 12:25 pm 
Offline
Joined: Tue Aug 16, 2005 11:50 am
Posts: 181
Location: Douglasville, GA
this concerns me:
Code:
Completed the DB restore.
Sanity checking your restore...

Checking for the existance of the backup tar file...
Backup tar file exists. Checking the compression...
Compression looks OK. Checking backup tar file contents...
Generating a list of the backup contents...
tar: ./etc/mythtv/modules: Not found in archive
tar: ./etc/lirc: Not found in archive
tar: ./etc/htdigest: Not found in archive
tar: ./etc/apache2/apache2.conf: Not found in archive
tar: ./var/www/mythweb/.htaccess: Not found in archive
tar: Error exit delayed from previous errors
Generating a list of the directory contents...
Comparing directory versus backup contents...

then I get a MASSIVE diff output, then...
Code:
Warning, file lists are not identical!

Checking for the existance of the DB dump file...
DB dump file exists. Checking the compression...
Compression looks OK. Checking DB dump contents...
Generating a list of tables and record counts in the DB dump...
Generating a list of tables and record counts in the live DB...
Comparing live versus saved tables...
Live and saved table lists match.

The restore failed or was already modified!
Doing any needed file updates...
Starting MythTV server: mythbackend.

I'm not at home to see if I have my recordings are available. (It seems that KM runs VNC, can I use that for remote testing?)
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Wed Dec 27, 2006 12:35 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
That would most likely occur because the merged archive doesn't have the names in the expected format. Do a:
Code:
tar ztvf savedfiles.tar.gz >/tmp/files.txt

and PM me the output.
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 


Board index KnoppMyth General

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 8 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