LinHES Forums http://forum.linhes.org/ |
|
Fried database - can I upgrade without a good backup http://forum.linhes.org/viewtopic.php?f=6&t=6905 |
Page 1 of 1 |
Author: | khrusher [ Sun Nov 13, 2005 8:57 am ] |
Post subject: | Fried database - can I upgrade without a good backup |
lots of lessons learned last night... I was attempting to rip for the first time since I upgraded months ago from R4V5 to R5A16 with no luck. After some tinkering I noticed that my CD and DVD device files and links were not alligned. I finally figured out that /dev/cdrom1 was pointing to my DVD hardware. Then I got to a point where I could run xine via command line and read a DVD using PINEAPPLE. however, running a mythtv yeilded PINEAPPLE errors. it was late, I was tired some how when trying to run mythfrontend, file completion gave me mythrestore. (must have missed the 'f') So mythrestore ran, using MONTHS old R4V5 data into my R5A16 database. Basically, I hosed everything. I'm assuming that a rebuild is in order, butI would like to keep the data on the /myth patition....but I dont want to have mythrestore run following the upgrade. Which is the latest, usable R5 version...is it R5A22? I have just about all of them burned to disk. I'm not looking for a real 'testing' version I'm looking for mostly stable for the production box I'm not particually concerned about the tv recordings...there are a couple that I would like to pull out and watch once. I want the /myth/video data and i would like to use /myth to save scripts and other data files. Lessons learned: - chmod -x mythrestore....easier to deal with permissions when I REALLY want to run it. - run mythbackup more often...at least after an upgrade has stablized. - late night work is dangerous....expecially on a fuzzy xterm window on a tv (ugg) |
Author: | tjc [ Sun Nov 13, 2005 10:21 am ] |
Post subject: | |
My recollection is that you can use the upgrade option with a missing or partial backup. What I would do in your place is run the backup script and delete the DB file from the /myth/backup directory. The file to delete is /myth/backup/mythconverg.sql. Before running the backup script make the following minimal fix to move the cd / command to the right place. That way you won't lose everything under /root and /home and will have a good reference copy of /etc. Code: root@black2:~# diff /usr/local/bin/mythbackup.orig /usr/local/bin/mythbackup.fix
16c16 < cd / --- > 24a25 > cd / |
Author: | khrusher [ Sun Nov 13, 2005 1:35 pm ] |
Post subject: | |
ah, I forgot about the no-db parts of the restore....did home, etc get clobbered with R4V5 pieces. I thin I need to blow away /myth/backup and save anything I need in /myth/I_screwed_up...then run the upgrade. As for cleanup after that....Are all these true 1) all files in /myth/video should get picked up 2)files in /myth/tv will be orphaned. I think there are a few shows I want...If I can figure out the files I can move them to /myth/video 3) music...I think I can just rescan, right? I dont have (much) games or gallery items. Looks like rebuild. This is when I wish stuff like time server client, dyndns client, mozilla were part of the install. Its the post install stuff that is a pain. |
Author: | tjc [ Sun Nov 13, 2005 4:46 pm ] |
Post subject: | |
The answer to most of your questions is yes, but I'd still go with a "use the backup for the parts you want" strategy.
- run the fixed backup script - delete the sql dump file - do a normal auto-upgrade. This should do the right thing and not damage the stuff in the /myth partition. |
Author: | mjl [ Sun Nov 13, 2005 7:43 pm ] |
Post subject: | |
Hi khrusher, You may have messed up the settings, however you shouldn't have hurt the system. It is a good excuse to upgrade though ![]() Do a backup when done ![]() Mike |
Author: | khrusher [ Sun Nov 13, 2005 10:02 pm ] |
Post subject: | |
what is a tv recordings rescan? |
Author: | mjl [ Mon Nov 14, 2005 6:33 am ] |
Post subject: | |
Hi khrusher, Thinking faster than I type I guess, the re-scan of the music should pick them up, The tv recordings will have lost their identity in the data base. If you had mythlink running, you might be able to copy them out as a mpg video. As I said, the system should be ok. Sorry about the missings words on previous post Mike |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |