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