View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: mysql db question
PostPosted: Sat Oct 14, 2006 11:51 pm 
Offline
Joined: Wed Jun 14, 2006 7:00 am
Posts: 3
OK, this may be impossible, but here goes:

I had a nice, customized and non-recently-backed-up knoppmyth install that I messed up the kernel for, so now it won't boot (tried to fix it for way too long today). So, I took the HDD upgrade opportunity and just installed a nice, new R5D1 install. My question is, is there any handy way to get all the settings of my old install (still have the HDD and it's mountable) into/onto my new install? Yes, there's a difference in the knoppmyth versions: I think the old one was R5B1... Knowing dangerously nothing about mysql dbs, I'm wondering if I can just swap out the settings.MYD/MYI/frm files from the old db...

Thanks.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 15, 2006 1:26 am 
Offline
Joined: Sat Jul 23, 2005 4:15 pm
Posts: 28
Location: Calgary, Canada
I do not believe the settings table changed from R5B to R5D but i am not too sure....you could backup the R5D database and then import the R5B database and if it goes badly then put the R5D backup back.

I think it should work though.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 15, 2006 8:42 am 
Offline
Joined: Wed Jun 14, 2006 7:00 am
Posts: 3
Thanks, I'll try it. If anyone else is reading this, the broken version is R5B7, not 1...if it matters.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 15, 2006 8:58 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Cecil wrote up how to make a backup on a damaged disk image a while back. I think it may have even been made into a wiki page. http://www.knoppmythwiki.org/index.php? ... erRecovery

Not mentioned on that page is booting from the CD, mounting /dev/hda1 (or your equivalent) and then using chroot to make it your root, then mounting /myth and running a backup.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Oct 15, 2006 12:16 pm 
Offline
Joined: Wed Jun 14, 2006 7:00 am
Posts: 3
Thanks everyone. I'll look into that backup/recovery strategy, and I'll just plain back up more often... I know better. FYI: swapping out the entire /var/lib/mysql dir worked fine, and I haven't found a glitch yet (though admittedly, I haven't done everything yet). This carried over all the recording db entries, so I just copied over the /myth/tv dir and voila.


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 13 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:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu