summaryrefslogtreecommitdiff
path: root/doc/sqlite-database.markdown
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2017-01-29 11:07:42 -0500
committerFrederic Guillot <fred@kanboard.net>2017-01-29 11:07:42 -0500
commit0371acff89b14b9bdcb03e72fd9637e26e6b517c (patch)
treef5878c9c07705379d137843cb8f92e3cdf7c20a8 /doc/sqlite-database.markdown
parent3bf4789be255650b64f42231f41383cb13b65572 (diff)
Move English documentation to folder en_US
Diffstat (limited to 'doc/sqlite-database.markdown')
-rw-r--r--doc/sqlite-database.markdown50
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).