Project

General

Profile

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>