On 4 Jun 2018, at 11:21pm, Rael Bauer wrote:
> On tree page 51 cell 1: invalid page number 302055426
Erm ... I don't know your pagesize and page count, but that looks like an
incorrectly high page number to me.
If you have checked that your recovery method does recover all the data you'd
expe
@david: I am not corrupting the database myself. Users of my application
have sent in corrupted databases (on very rare occassion).
I do not have permission to send you corrupted database at this time.
I can tell you the following:
This problem starts with v3.18.
It works ok with v3.17
Databa
users-boun...@mailinglists.sqlite.org] On
Behalf Of Rael Bauer
Sent: Monday, June 04, 2018 1:33 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] Repair corrupt database results in 0KB file
@Simon: I did not mention any sqlite3.dll. I am only talking about
sqlite3.exe command line tool. T
On 4 Jun 2018, at 6:32pm, Rael Bauer wrote:
> The last line in the dump using the latest version (3.23.1) is:
>
> ROLLBACK; -- due to errors
Then there are errors, and the data in your database may be corrupt, and the
information you're getting from it can be wrong. Use the command-line tool
@Simon: I did not mention any sqlite3.dll. I am only talking about
sqlite3.exe command line tool. The problem occurs using the command line.
Yes, I tried your idea.
The last line in the dump using the old version is:
COMMIT;
The last line in the dump using the latest version (3.23.1) is:
ROL
On 4 Jun 2018, at 6:00pm, Rael Bauer wrote:
> Now I updated to the latest version (3.23.1),
Which did you update ? The command-line tool you call as sqlite3, or the
library used in the program which uses the database file ? Or both ?
> and using the above method results in a 0 KB file.
Brea
Hello,
I having been using the following method to repair corrupt databases
using sqlite3.exe:
Simply call: sqlite3 mydata.db ".dump" | sqlite3 new.db
(source:
https://stackoverflow.com/questions/18259692/how-to-recover-a-corrupt-sqlite3-database)
I have been using an old version of sqlite3
7 matches
Mail list logo