diff options
author | Frederic Guillot <fred@kanboard.net> | 2017-01-29 11:07:42 -0500 |
---|---|---|
committer | Frederic Guillot <fred@kanboard.net> | 2017-01-29 11:07:42 -0500 |
commit | 0371acff89b14b9bdcb03e72fd9637e26e6b517c (patch) | |
tree | f5878c9c07705379d137843cb8f92e3cdf7c20a8 /doc/sqlite-database.markdown | |
parent | 3bf4789be255650b64f42231f41383cb13b65572 (diff) |
Move English documentation to folder en_US
Diffstat (limited to 'doc/sqlite-database.markdown')
-rw-r--r-- | doc/sqlite-database.markdown | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/doc/sqlite-database.markdown b/doc/sqlite-database.markdown deleted file mode 100644 index 0a6a0ab6..00000000 --- a/doc/sqlite-database.markdown +++ /dev/null @@ -1,50 +0,0 @@ -Sqlite database management -========================== - -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`. - -Export/Backup -------------- - -### Command line - -Doing a backup is very easy, just copy the file `data/db.sqlite` somewhere else when nobody use the software. - -### User interface - -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`. - -Import/Restoration ------------------- - -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. - -- To restore an old backup, just replace and overwrite the actual file `data/db.sqlite`. -- To uncompress a gzipped database, execute this command from a terminal `gunzip db.sqlite.gz`. - -Optimization ------------- - -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: - -- Reduce the file size, deleting data produce empty space but doesn't change the file size. -- The database is fragmented due to frequent inserts or updates. - -### From the command line - -``` -sqlite3 data/db.sqlite 'VACUUM' -``` - -### From the user interface - -Go to the menu **settings** and click on the link **Optimize the database**. - -For more information, read the [Sqlite documentation](https://sqlite.org/lang_vacuum.html). |