Re: [sqlite] SQL error: database disk image is malformed - other possibility than dump/load

2009-08-12 Thread Александр Готманов
> So if the corruption problem is > confined to an index or indexes, an export/import will fix > problem but a vacuum will not. > Dan. I ran into exactly that problem with Sqlite database used by Trac (http://trac.edgewall.org/). The solution Dan proposed here worked fine for me. That's what I d

Re: [sqlite] SQL error: database disk image is malformed - other possibility than dump/load

2009-07-31 Thread Dan Kennedy
On Jul 31, 2009, at 12:00 AM, rupert.thurner wrote: > is there another possibility but exporting and importing the data to > get rid of: > SQL error: database disk image is malformed > ? > > here the details of the error and the commands we used. but we are not > sure why exporting works and va

[sqlite] SQL error: database disk image is malformed - other possibility than dump/load

2009-07-31 Thread rupert.thurner
is there another possibility but exporting and importing the data to get rid of: SQL error: database disk image is malformed ? here the details of the error and the commands we used. but we are not sure why exporting works and vacuum should not work. we used sqlite 3.6.10, solaris. # sqlite3 t