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