Re: [sqlite] Malformed database recovery

2013-05-14 Thread Marcin
Of course, I understand that I haven't recovered everything, but as I said before, I don't find any big ammount of data lost ;) Sent: Tuesday, May 14, 2013 5:59 PM Subject: Re: [sqlite] Malformed database recovery On 14 May 2013, at 4:54pm, "Marcin" <ign...@op.pl> wrote: O

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Simon Slavin
On 14 May 2013, at 4:54pm, "Marcin" wrote: > 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.

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Marcin
ubject: 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

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Adam DeVita
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 > > >

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Marcin
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

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Adam DeVita
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 wrote: > Hi everybody. > > Somehow my database got malformed, and journal file is unfortunately > nowhere to found. > >

[sqlite] Malformed database recovery

2013-05-14 Thread Marcin
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