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