Olaf Beckman Lapré wrote:
I've done some tests by modifying the .db file with a hex editor, to
simulate a corrupt database
How do I repair the database?
I can think of only two possibilities other than the things already
discussed in this thread:
1) Undo the modifications made with
or message
I get is: malformed database schema - unrecognized token '#'
How do I repair the database?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 01, 2006 1:35 PM
Subject: Re: [sqlite] Reading a damaged database file?
Gunnar Roth wrote:
Olaf Beckman Lapré schrieb:
Hi,
Is there a way to do this programmatically? I would like to recover
from a
damaged database upon program startup.
1. Copy the code for dump command from shell.c
2. Try if "vacuum;" command repairs the database. with "pragma
[EMAIL PROTECTED] schrieb:
Gunnar Roth <[EMAIL PROTECTED]> wrote:
Well what happens if i write the db to a compact flash card and remove
it while writing and put it back again?
The database should recover automatically.
Actually i have tried that on our ce device while
.
So far the SQLite database has behaved very well and it's very fast.
Olaf
- Original Message -
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 01, 2006 12:35 PM
Subject: Re: [sqlite] Reading a damaged database file?
=?utf-8?Q?Olaf_Beckma
Gunnar Roth <[EMAIL PROTECTED]> wrote:
> >
> Well what happens if i write the db to a compact flash card and remove
> it while writing and put it back again?
The database should recover automatically.
> Actually i have tried that on our ce device while importing cvs records
> with .read
[EMAIL PROTECTED] schrieb:
=?utf-8?Q?Olaf_Beckman_Lapr=C3=A9?= <[EMAIL PROTECTED]> wrote:
Hi,
Is there a way to do this programmatically? I would like to recover from a
damaged database upon program startup.
If your program crashes, or your computer loses power in the
middle of a
Olaf Beckman Lapré schrieb:
Hi,
Is there a way to do this programmatically? I would like to recover from a
damaged database upon program startup.
1. Copy the code for dump command from shell.c
2. Try if "vacuum;" command repairs the database. with "pragma
integrity_check;" you can check
=?utf-8?Q?Olaf_Beckman_Lapr=C3=A9?= <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there a way to do this programmatically? I would like to recover from a
> damaged database upon program startup.
>
If your program crashes, or your computer loses power in the
middle of a database change, and thus
t: 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
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
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.
Olaf
12 matches
Mail list logo