Trac – Fixing the SQLite DB

Thanks to http://www.otterbook.com/blog/2009/08/fixing-the-sqlite-db-for-a-trac-instance/ , I found out how to fix a Trac instance when I got the message

“DatabaseError: database disk image is malformed”

Here it is:

$ cd /path/to/trac-sqlite-db-directory # find the trac.db file
$ su www-data   # switch to the owner of the db file
$ mv trac.db trac.db.damaged
$ sqlite3 trac.db.damaged .dump|sqlite3 trac.db