Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: registration information problem Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
rschneid
Newbie
Newbie
Avatar

Joined: December 30 2009
Location: United States
Online Status: Offline
Posts: 8
Posted: November 30 2010 at 17:46 | IP Logged Quote rschneid

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 View rschneid's Profile Search for other posts by rschneid
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: November 30 2010 at 19:21 | IP Logged Quote TonyNo

I'd say try running the phupg tool.
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
rschneid
Newbie
Newbie
Avatar

Joined: December 30 2009
Location: United States
Online Status: Offline
Posts: 8
Posted: November 30 2010 at 19:36 | IP Logged Quote rschneid

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 View rschneid's Profile Search for other posts by rschneid
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: November 30 2010 at 19:55 | IP Logged Quote dhoward

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 View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
rschneid
Newbie
Newbie
Avatar

Joined: December 30 2009
Location: United States
Online Status: Offline
Posts: 8
Posted: November 30 2010 at 20:25 | IP Logged Quote rschneid

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 View rschneid's Profile Search for other posts by rschneid
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: November 30 2010 at 20:59 | IP Logged Quote dhoward

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 View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum