summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2015-10-05 22:10:25 -0400
committerFrederic Guillot <fred@kanboard.net>2015-10-05 22:10:25 -0400
commitca62d68788d17b063a5641325f597f5342328841 (patch)
tree8d9a1e20797578cbfa053a1d7245fc5f385f4526 /doc
parent793763681d2ab3b1627c4e0e6c907e884038b2dc (diff)
Add Mysql and Postgres schema (SQL dump)
Diffstat (limited to 'doc')
-rw-r--r--doc/mysql-configuration.markdown13
-rw-r--r--doc/postgresql-configuration.markdown12
2 files changed, 25 insertions, 0 deletions
diff --git a/doc/mysql-configuration.markdown b/doc/mysql-configuration.markdown
index eef1e125..554bec3b 100644
--- a/doc/mysql-configuration.markdown
+++ b/doc/mysql-configuration.markdown
@@ -42,3 +42,16 @@ define('DB_NAME', 'kanboard');
```
Note: You can also rename the template file `config.default.php` to `config.php`.
+
+### Importing SQL dump (alternative method)
+
+The first time, Kanboard will run one by one each database migration and this process can take some time according to your configuration.
+
+To avoid any issues or potential timeouts you can initialize the database directly by importing the SQL schema:
+
+```bash
+mysql -u root -p my_database < app/Schema/Sql/mysql.sql
+```
+
+The file `app/Schema/Sql/mysql.sql` is a sql dump that represent the last version of the database.
+
diff --git a/doc/postgresql-configuration.markdown b/doc/postgresql-configuration.markdown
index 3c07ff16..904dfc0f 100644
--- a/doc/postgresql-configuration.markdown
+++ b/doc/postgresql-configuration.markdown
@@ -38,3 +38,15 @@ define('DB_NAME', 'kanboard');
```
Note: You can also rename the template file `config.default.php` to `config.php`.
+
+### Importing SQL dump (alternative method)
+
+The first time, Kanboard will run one by one each database migration and this process can take some time according to your configuration.
+
+To avoid any issues or potential timeouts you can initialize the database directly by importing the SQL schema:
+
+```bash
+psql -U postgres my_database < app/Schema/Sql/postgres.sql
+```
+
+The file `app/Schema/Sql/postgres.sql` is a sql dump that represent the last version of the database.