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
