SQLite » History » Version 2
« Previous -
Version 2/4
(diff) -
Next » -
Current version
pennywise, 07/02/2009 05:18 PM
SQLite¶
Cleanup of the database¶
- You could use vacuum http://www.sqlite.org/lang_vacuum.html
- 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