Table of Contents
Kanboard uses Sqlite by default to store its data. All tasks, projects and users are stored inside this database.
Technically, the database is just a single file located inside the directory data
and named db.sqlite
.
Doing a backup is very easy, just copy the file data/db.sqlite
somewhere else when nobody use the software.
If you want to do a backup while users are connected, you can use sqlite3
to create the backup.
sqlite3 db.sqlite .dump > kanboard.dump.sql
sqlite3 db.sqlite ".backup kanboard.backup.sqlite"
You can also download at any time the database directly from the Settings menu.
The downloaded database is compressed with Gzip, the filename becomes db.sqlite.gz
.
There is actually no way to restore the database from the user interface. The restoration must be done manually when no body use the software.
data/db.sqlite
.gunzip db.sqlite.gz
.sqlite3 db.sqlite < kanboard.dump.sql
(db.sqlite must not exist)sqlite3 db.sqlite ".restore kanboard.backup.sqlite"
Occasionally, it’s possible to optimize the database file by running the
command VACUUM
. This command rebuild the entire database and can be
used for several reasons:
sqlite3 data/db.sqlite 'VACUUM'
Go to the Settings menu and click on the link Optimize the database.
For more information, read the Sqlite documentation.
DB_WAL_MODE
to false
.