Jordan Hayes wrote:
>
> Where would the file be?
It would be "beside" the database file, i.e. in the same directory as
the database file. The journal only exists while sqlite is modifying the
database. When a change has been completed successfully, the journal
file is deleted.
> I don't
Hello!
В сообщении от Friday 29 August 2008 02:29:37 D. Richard Hipp написал(а):
> Run this command:
>
> sqlite3 old.db .dump | sqlite3 new.db
This command lost information about page size ans some other.
Best regards, Alexey.
___
sqlite-users
>> I had a power failure yesterday and an active database of
>> mine is now trashed.
>
> I'm curious how you got to this point. If the power failed during a
> transaction there should have been a rollback journal file beside the
> database file which the sqlite library would discover and use to
Jordan Hayes wrote:
> I had a power failure yesterday and an active database of mine is now
> trashed. The output of "pragma integrity_check" includes lots of
>
> rowid missing from index MyIndexName
>
> and
>
> wrong # of entries in index OtherIndexName
>
> messages.
>
> Plus
On Aug 28, 2008, at 5:59 PM, Jordan Hayes wrote:
> I had a power failure yesterday and an active database of mine is now
> trashed. The output of "pragma integrity_check" includes lots of
>
>rowid missing from index MyIndexName
>
> and
>
>wrong # of entries in index OtherIndexName
I had a power failure yesterday and an active database of mine is now
trashed. The output of "pragma integrity_check" includes lots of
rowid missing from index MyIndexName
and
wrong # of entries in index OtherIndexName
messages.
Plus this:
On tree page 4 cell 17: 2nd
6 matches
Mail list logo