Author |
|
rschneid Newbie
Joined: December 30 2009 Location: United States
Online Status: Offline Posts: 8
|
Posted: November 30 2010 at 17:46 | IP Logged
|
|
|
I started the db utility tool to back up my db. Since I had never run the log trimming tool, I guess it was pretty big. It looks like something went wrong, and now PH won't start. I get an error msg about "failure to retrieve registration information". Anyone know how to fix this? Is my db toast?
Rich S.
__________________ Rich Schneider
|
Back to Top |
|
|
TonyNo Moderator Group
Joined: December 05 2001 Location: United States
Online Status: Offline Posts: 2889
|
Posted: November 30 2010 at 19:21 | IP Logged
|
|
|
I'd say try running the phupg tool.
|
Back to Top |
|
|
rschneid Newbie
Joined: December 30 2009 Location: United States
Online Status: Offline Posts: 8
|
Posted: November 30 2010 at 19:36 | IP Logged
|
|
|
I think that that is what I ran which seems to have caused the problem in the first place. Any other ideas? I am dead in the water here.
Rich S.
__________________ Rich Schneider
|
Back to Top |
|
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: November 30 2010 at 19:55 | IP Logged
|
|
|
Rich,
If you originally ran the phupg tool, it would have make a backup of your database before doing anything. Check in your PowerHome database directory (default c:\program files\powerhome\database) and you should see your backup copy (it should have a date/time stamp of today or whenever you ran the phupg tool).
With PowerHome and the phupg tool not running, make a copy of the existing pwrhome.db file (just in case), delete the existing pwrhome.db file and then make a copy of your backup file and rename it to pwrhome.db. This should get you back to where you were before you ran anything. Launch PowerHome and then try the ph_trimeventlog function to reduce your eventlog size. Once that completes, try the phupg utility again (make a new backup...don't want to risk overwriting any files) and try to compress/rebuild your database. Once you've got a clean, small version of your database that launches, you can then clean up any extra backups.
Dave.
|
Back to Top |
|
|
rschneid Newbie
Joined: December 30 2009 Location: United States
Online Status: Offline Posts: 8
|
Posted: November 30 2010 at 20:25 | IP Logged
|
|
|
Dave, I don't know if the backup did the right thing, but I don't think so. My memory (sketchy) is that I had a db file in the 808,000,000 byte range. Now I have three files, as below, all the same exact size. Its therefore possible/likely that I ran the backup twice, and may have backed up the the new version over the original backup. I am thinking about doing nothing, first, and running some file recovery stuff, before I make any more copies on the off chance that i can recover my original db. Or am I overly paranoid and should just try switching the 7:48 PM version with the 5:41 PM version and see what happens? Opinion?
Rich S.
What I can see right now:
ph21b.db - 2,441,216 - 01/11/2010
pwrhome.21b.db - 2,441,216 - 11/30/2010 5:41PM
pwrhome.db - 2,441,216 - 11/30/2010 7:48PM
Rich S.
__________________ Rich Schneider
|
Back to Top |
|
|
dhoward Admin Group
Joined: June 29 2001 Location: United States
Online Status: Offline Posts: 4447
|
Posted: November 30 2010 at 20:59 | IP Logged
|
|
|
Hmmm...if you ran the phupg utility twice (and overwrote the original backup) then you're probably hosed.
The ph21b.db file is the base, empty database file that is used by the phupg utility. pwrhome.db would normally be your production PowerHome database file. When you launch the phupg util and start an upgrade/rebuild, the first thing it does is ask for a backup name. Your pwrhome.db file is then renamed to this value (its not copied because that could introduce errors or take an extremely long time like in the case of an 808 MB file). The ph21b.db file is then copied to pwrhome.db. The phupg util will then work with these files, opening your renamed database (the backup) in read only mode and updating the pwrhome.db file (a copy of the empty database).
If there is some failure and you rerun the util and use the same backup name, your backup database would have been ultimately overwritten by what is basically the empty database file. This is why you've got 3 database files all of the same size (basically empty).
You can try a file recovery utility but I would be surprised if its successful. Definitely wouldnt hurt to try because I know how catastrophic data loss can be.
Dave.
|
Back to Top |
|
|