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
Doing a backup is very easy, just copy the file
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
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.
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
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.