possible database coruption question

Derek Atkins warlord at MIT.EDU
Fri Jun 20 23:52:55 CDT 2003


There are two sets of files, .log and .xac.  The .log files
are just that, logs of your actions.  The .xac files are
actual datafile backups.

-derek

Jim Hartzell <wa3uqd at nauticom.net> writes:

> Thanks for the quick reply. I have been reading the archives of this
> list and found a thread on scheduled transactions that matches my
> problem on start-up. I turned off scheduled transactions and can now get
> to my data, it appears to be correct. 
> 
> I tried the backup files and they seem to be incremental not full
> backups, they only contain 3 or 4 transactions each. I also have files
> in ~Finance directory
> IE:"Accounts.20030616221447.xac.20030619204002.log". I also have files
> IE: "Accounts.20030616221447.xac.7f0100.3092.LNK".
> What are they? Is there any documentation explaining the backup system?
> What file(s) do I need to backup to tape?
> 
> Jim
>  
> 
>  On Thu, 2003-06-19 at 22:55, Derek Atkins wrote:
> > Well, if you were in the process of saving the file when the power
> > went out it's certainly possible the save was corrupted.  Go find
> > the most recent backup copy and restore from there.  GnuCash saves 30
> > days worth of backups.  So, if your file is named "accounts", your
> > backups will be named "accounts.YYYYMMDDHHMMSS.xac".  Just copy the most
> > recent backup file into a new data file, "accounts2" and try opening
> > that.
> > 
> > Note that you'll not have your most recent changes, but it should at
> > leave give you a working datafile.
> > 
> > -derek
> > 
> > Jim Hartzell <wa3uqd at nauticom.net> writes:
> > 
> > > I am new to gnucash 2 months, great program. I am using version 1.8.1 on
> > > RH9. I am not sure how to state the problem correctly, but here goes.
> > > I had a power failure while gnucash was running (no UPS). Now when I
> > > tried to run gnucash I get an error message that it cannot get a lock
> > > that another user may have it open, clicking " open anyway " I get 2
> > > corrupt windows, 1 has just a title bar the other is blank. clicking on
> > > the "X" doesn't close them, I had to kill the gnucash process. Clicking
> > > on create new file works, I created dummy accounts, they work fine. If I
> > > do a file open from the dummy accounts on the original accounts same
> > > problem.
> > > Help. How do I fix this problem?
> > > Jim
> > > 
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at lists.gnucash.org
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at lists.gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list