Board index » delphi » DB corrupted

2005-06-10 06:20:21 PM
delphi100
Hi there,
I'm having a trouble from which I don't know how to recover. There is no
backup or any other mean of recovery so all I have is a corrupted GDB
file; the good news is that I can access it and all its data so I
suppose I could dump its data to a new and empty DB. Does anyone knows a
tool or a way of dumping all the data of a DB to a file so it can be
loaded afterwards into an empty DB? (something similar to the isql
metadata extraction).
The error I am trying to recover from is a "Partner index not found". I
couldn't recover from it even after reading all the doc I found. My main
problem is that I only have a GBK which seems to be already damaged
althought I can restore it I can not create any index as an error arises.
I read on the Internet it could be recovered from the original GDB (as
it seems this error comes from a badly performed backup) but all I have
is the GBK.
So my plan was to dump all the data from this DB to a new and empty one;
I think this can be done by deactivating all the indexes and triggers,
loading the data and activating indexes and triggers afterwards. That's
why I'd need that dump/load tool.
Any suggestion will be more than welcome.
Best regards and many thanks in advance.
 

I reply to myself as I already found a solution just in case it can help
someone:
I found the tool DataPump
(<www.clevercomponents.com/downloads/datapump/dpdownload.asp>)
which pumps data between DBs. It did the job for me.
Best regards
Hector Sanchez Sanmartin writes: