SQLite » History » Version 2
pennywise, 07/02/2009 05:18 PM
| 1 | 1 | pennywise | h1. SQLite |
|---|---|---|---|
| 2 | 1 | pennywise | |
| 3 | 1 | pennywise | h2. Cleanup of the database |
| 4 | 1 | pennywise | |
| 5 | 1 | pennywise | * You could use vacuum http://www.sqlite.org/lang_vacuum.html |
| 6 | 1 | pennywise | * You can dump the database and import it again. You have to stop quassel(core) for this: |
| 7 | 1 | pennywise | |
| 8 | 1 | pennywise | <pre> |
| 9 | 2 | pennywise | mv ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.config/quassel-irc.org/quassel-storage.sqlite.bak |
| 10 | 2 | pennywise | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite |
| 11 | 1 | pennywise | </pre> |