Repairing corrupt databases

[Ruslan Zasukhin]

On 7/6/06 9:23 PM, "Chuck Neal" <chuck at mediamacros.com> wrote:

Hi Chuck,

> I am running into problems where over time adding and removing records
> starts corrupting my database.  It will create records with empty fields
> or give me index errors on diagnosis about how it expects x number of
> records and gets y instead.  That's all fine except that there is no way
> to fix it.  I have tried doing a dump to XML, dump to SQL, etc and they

Db.Clone -- should be considered as best and fastest way to fix corrupted
db.


> all die with a kernel error.  Studio will just die if I try to even
> scroll to one of these records.  It seems that most of the errors are
> items I have deleted so its not causing critical problems with live data
> but over time the database gets more and more corrupt causing search
> errors, incomplete SQL results (if a bad record is in the set it finds)
> and eventually hosing the file.
> 
> Is there any other reliable way to get all the data back out and
> rebuild/fix the database?
> 
> This is using version 2.1 in Director as well as with Studio.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]