> 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 did: # ls trac.db # sqlite3 trac.db (sqlite3 prompt) # .output full.dump (sqlite3 prompt) # .dump # sqlite3 trac.repaired.db (sqlite3 prompt) # .read full.dump (sqlite3 prompt) # PRAGMA integrity_check; ok mv trac.db trac.broken.db cp trac.repaired.db trac.db It all works now, as it used to. Lucky escape for me, we keep a lot valuable information in Trac wiki pages, though maybe we shouldn't. My thanks to Dan. Alexander. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
