annotate docs/usage/backup.rst @ 5619:6353b5e87091

ini: specify utf8 for sample MySQL connection strings By default, the MySQL stack will store unicode as UTF-8 encoded data in string fields, thus without using any unicode capabilities in the database. As described in http://docs.sqlalchemy.org/en/latest/dialects/mysql.html#mysql-unicode , set charset=utf8 to actually put unicode in the database. Existing databases that already store utf8 in the database should keep using the old url. This will only support 16 bit code points, but utf8mb4 will double the key size and make them too big for MySQL.
author Mads Kiilerich <madski@unity3d.com>
date Tue, 05 Jan 2016 16:30:11 +0100
parents fbbe80e3322b
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1104
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
1 .. _backup:
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
2
2095
Marcin Kuzminski <marcin@python-works.com>
parents: 1104
diff changeset
3 ====================
4192
e73a69cb98dc Rename some strings examples and commands in documentation
Bradley M. Kuhn <bkuhn@sfconservancy.org>
parents: 3224
diff changeset
4 Backing up Kallithea
1104
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
5 ====================
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
6
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
7
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
8 Settings
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
9 --------
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
10
4192
e73a69cb98dc Rename some strings examples and commands in documentation
Bradley M. Kuhn <bkuhn@sfconservancy.org>
parents: 3224
diff changeset
11 Just copy your .ini file, it contains all Kallithea settings.
1104
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
12
5433
fbbe80e3322b docs: consistent spacing around headings
Mads Kiilerich <madski@unity3d.com>
parents: 4955
diff changeset
13
1104
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
14 Whoosh index
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
15 ------------
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
16
4955
4e6dfdb3fa01 docs: English and consistency corrections
Michael V. DePalatis <mike@depalatis.net>
parents: 4192
diff changeset
17 The Whoosh index is located in the ``data/index`` directory where you installed
4e6dfdb3fa01 docs: English and consistency corrections
Michael V. DePalatis <mike@depalatis.net>
parents: 4192
diff changeset
18 Kallithea, i.e., the same place where the ini file is located
1104
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
19
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
20
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
21 Database
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
22 --------
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
23
4192
e73a69cb98dc Rename some strings examples and commands in documentation
Bradley M. Kuhn <bkuhn@sfconservancy.org>
parents: 3224
diff changeset
24 When using sqlite just copy kallithea.db.
1104
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
25 Any other database engine requires a manual backup operation.
af371e206ec5 added backup to docs
Marcin Kuzminski <marcin@python-works.com>
parents:
diff changeset
26
4955
4e6dfdb3fa01 docs: English and consistency corrections
Michael V. DePalatis <mike@depalatis.net>
parents: 4192
diff changeset
27 A database backup will contain all gathered statistics.