SQLite » History » Version 2
Version 1 (pennywise, 07/02/2009 05:12 PM) → Version 2/4 (pennywise, 07/02/2009 05:18 PM)
h1. SQLite
h2. 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:
<pre>
mv ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.config/quassel-irc.org/quassel-storage.sqlite.bak ~/.quassel/quassel-storage.sqlite ~/.quassel/quassel-storage.sqlite.bak
sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak ~/.quassel/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.quassel/quassel-storage.sqlite
</pre>
h2. 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:
<pre>
mv ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.config/quassel-irc.org/quassel-storage.sqlite.bak ~/.quassel/quassel-storage.sqlite ~/.quassel/quassel-storage.sqlite.bak
sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak ~/.quassel/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite ~/.quassel/quassel-storage.sqlite
</pre>