Re: Reading a damaged database file?

Hi,

Is there a way to do this programmatically? I would like to recover from a
damaged database upon program startup.

Regards,

Olaf

----- Original Message ----- 
From: "Christian Smith" <csmith@...>
To: "SQLite Mailing List" <sqlite-users@...>
Sent: Monday, July 31, 2006 4:53 PM
Subject: Re: [sqlite] Reading a damaged database file?

Olaf Beckman Lapr uttered:

> Hi,
>
> Is it possible to read the undamaged parts of a damaged .db file? This
> way I can copy the undamaged parts to another database. Or support to
> repair the .db file in such a way that it becomes readable again and the
> undamaged parts can be read.

You can try doing a .dump from the SQLite shell. It will dump out as much
data that can be read without errors.

>
> Olaf

--
     /"\
     \ /    ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
      X                           - AGAINST MS ATTACHMENTS
     / \