Ok, I had a great idea, and propably somehow managed to repair it. I opened
dump_all.sql in notepad, deleted two "/**** ERROR: (11) database disk image
is malformed *****/", changed ROLLBACK into COMMIT, and it is working so
far.
ignac8
Sent: Tuesday, May 14, 2013 5:48 PM
Subject: Re: [sqlite] Malformed database recovery
If you can get the errors, by say redirecting the output from the .read to
a file, the error message will likely be enlightening. When I recover
corrupt db files, there are often some records with a conflicting primary
key. In those cases I have to edit the input to fix the old one.
Naturally, you desire a commit rather than a rollback when your .read can
execute with no errors.
Others on the list are far better at explaining the output of the
integrity
check than I am.
Adam
On Tue, May 14, 2013 at 11:40 AM, Marcin <ign...@op.pl> wrote:
No errors, but tshockfixed.sqlite is empty, and in the end of file
dump_all.sql there is "ROLLBACK; -- due to errors".
It's was check of tshock.sqlite, old one.
ignac8
Sent: Tuesday, May 14, 2013 4:43 PM
Subject: Re: [sqlite] Malformed database recovery
Where there any errors on
.read dump_all.sql ?
was PRAGMA integrity_check; on the new file or the old one?
On Tue, May 14, 2013 at 10:29 AM, Marcin <ign...@op.pl> wrote:
Hi everybody.
Somehow my database got malformed, and journal file is unfortunately
nowhere to found.
Suprisingly, I'm able to open it in Sqlite Database Browser, and read
stored values. There is only minor data loss, as I can't really see
what
got missing. I've also managed to figure which table is damaged.
I've tried doing this:
sqlite3.exe tshock.sqlite
sqlite> .mode insert
sqlite> .output dump_all.sql
sqlite> .dump
sqlite> .exit
sqlite3.exe tshockfixed.sqlite
sqlite> .read dump_all.sql
sqlite> .exit
But it still returns malformed one.
PRAGMA integrity_check; returns this:
*** in database main ***
On tree page 3 cell 17: invalid page number 9049
On tree page 3 cell 17: Child page depth differs
On tree page 3 cell 18: Child page depth differs
On tree page 8948 cell 86: invalid page number 9047
On tree page 8948 cell 86: Child page depth differs
On tree page 8948 cell 87: invalid page number 9051
On tree page 8948 cell 88: invalid page number 9055
On tree page 8948 cell 89: Child page depth differs
On tree page 8948 cell 90: invalid page number 9061
On tree page 8948 cell 90: Child page depth differs
On tree page 8948 cell 91: invalid page number 9066
On tree page 8948 cell 92: invalid page number 9069
On page 8948 at right child: invalid page number 9074
On tree page 9039 cell 69: invalid page number 9046
On tree page 9039 cell 69: Child page depth differs
On tree page 9039 cell 70: invalid page number 9048
On tree page 9039 cell 71: invalid page number 9050
On tree page 9039 cell 72: invalid page number 9052
On tree page 9039 cell 73: invalid page number 9053
On tree page 9039 cell 74: invalid page number 9054
On tree page 9039 cell 75: invalid page number 9056
On tree page 9039 cell 76: invalid page number 9057
On tree page 9039 cell 77: invalid page number 9058
On tree page 9039 cell 78: invalid page number 9059
On tree page 9039 cell 79: invalid page number 9060
On tree page 9039 cell 80: invalid page number 9062
On tree page 9039 cell 81: invalid page number 9063
On tree page 9039 cell 82: invalid page number 9064
On tree page 9039 cell 83: invalid page number 9065
On tree page 9039 cell 84: invalid page number 9067
On tree page 9039 cell 85: invalid page number 9068
On tree page 9039 cell 86: invalid page number 9070
On tree page 9039 cell 87: invalid page number 9071
On tree page 9039 cell 88: invalid page number 9072
On tree page 9039 cell 89: invalid page number 9073
On tree page 9039 cell 90: invalid page number 9075
On tree page 9039 cell 91: invalid page number 9077
On page 9039 at right child: invalid page number 9076
Error: database disk image is malformed
Does anybody got an idea, and can help me?
ignac8
______________________________****_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users<http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users>
<http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
>
--
VerifEye Technologies Inc.
905-948-0015x245
151 Whitehall Dr, Unit 2
Markham ON, L3R 9T1
Canada
______________________________**_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
______________________________**_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
--
VerifEye Technologies Inc.
905-948-0015x245
151 Whitehall Dr, Unit 2
Markham ON, L3R 9T1
Canada
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
