n...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Thursday, August 05, 2010 4:40 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Repairing a Database.
On 4 Aug 2010, at 10:15pm, Kirk Clemons wrote:
> Also, does this mean that I could tak
On 4 Aug 2010, at 10:15pm, Kirk Clemons wrote:
> Also, does this mean that I could take a backup copy of my database and
> import the data that is retrieved from the .dump command on the corrupt
> database?
We cannot tell what .dump will get from your old database because it is
corrupt. It
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Roger Binns
Sent: Tuesday, August 03, 2010 5:56 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Repairing a Database.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/02/2010 07:42 AM, Kirk Clemons wrote:
>
tware
www.HomeDesignerSoftware.com
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Roger Binns
Sent: Tuesday, August 03, 2010 5:56 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Repairing a Database.
-BEGIN PGP S
nto a dog pound. ;)
Regards,
~Kirk.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Artur Reilin
Sent: Tuesday, August 03, 2010 7:51 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Repairing a Database.
If the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/02/2010 07:42 AM, Kirk Clemons wrote:
> I have seen some information on repairing a corrupt database and recovering
> at least some of the data. But I have not had any luck finding out how to do
> it.
You can use .dump in the shell. It does a
If the database is corrupted, then this is really bad. If you don't have a
backup of your file, then it's almost not really possible to repair the
database. As far as I know...
You could open the database in an editor and try to pick some data, that
was left in the database.
with best wishes
Art
Hello All,
I am new to SQLite and have run into an issue with a malformed database. It
seems the application using the database was shutdown prematurely during an
update operation and the journal file was never deleted. This means that on
startup the application used the wrong journal file and c
8 matches
Mail list logo
