Ask Your Question

Repair Corrupt ODB file [closed]

asked 2016-01-21 21:59:40 +0100

ztirffritz gravatar image

I have a database that doesn't have very much data in it, but for some reason, it now won't open. When I try to open it, it says that it is corrupted and needs to be repaired. It then opens a blank 'Writer' document instead of Base. I'm trying to avoid reverting to a backup, but I can do that if necessary.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-29 21:08:03.204054

2 Answers

Sort by » oldest newest most voted

answered 2016-02-09 19:43:54 +0100

I have been able to succesfully recover my ODB file based on an old backup file.

1) Backup both ODB files (damaged and backup) 2) Open both ODB files with any zip manager program (I used 7zip) 3) In the backup file delete in the "database" directory the files "data" and "script" 4) Copy to the backup file the same files ("data" and "script") from the damaged ODB (with 7zip you just have to drag and drop files from one window to the other) 5) Open the backup ODB and it will contain all the data from your damaged ODB

edit flag offensive delete link more

answered 2016-02-10 01:14:15 +0100

frofa gravatar image

It'll probably by easier and quicker to use your backup. The default 'embedded' mode that Base uses to connect to the underlying HSQLDB database is inherently risky and corruption prone, so I would suggest using the much more stable 'split' mode to connect to your database - see HERE for information on how to do that. (PS: I have been using 'split' Base databases for years and have not lost any data so far - even when crashes occur as they do occasionally).

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-01-21 21:59:40 +0100

Seen: 2,208 times

Last updated: Feb 10 '16