Project

General

Profile

SQLite » History » Version 3

« Previous - Version 3/4 (diff) - Next » - Current version
pennywise, 07/03/2009 08:51 AM


SQLite

Cleanup of the database

  • You could use vacuum
  • You can dump the database and import it again. You have to stop quassel(core) for this:
mv ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.config/quassel-irc.org/quassel-storage.sqlite.bak
sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite