SQLite » History » Version 3
Version 2 (pennywise, 07/02/2009 05:18 PM) → Version 3/4 (pennywise, 07/03/2009 08:51 AM)
h1. SQLite
h2. Cleanup of the database
* You could use "vacuum":http://www.sqlite.org/lang_vacuum.html 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
sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite
</pre>
h2. Cleanup of the database
* You could use "vacuum":http://www.sqlite.org/lang_vacuum.html 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
sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite.bak .dump | sqlite3 ~/.config/quassel-irc.org/quassel-storage.sqlite
</pre>