SQLite » History » Version 1
    
    Version 1/4
     - 
    Next ยป - 
    Current version
    
    pennywise, 07/02/2009 05:12 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 ~/.quassel/quassel-storage.sqlite ~/.quassel/quassel-storage.sqlite.bak sqlite3 ~/.quassel/quassel-storage.sqlite.bak .dump | sqlite3 ~/.quassel/quassel-storage.sqlite