summary refs log tree commit diff
path: root/scripts-dev/database-save.sh
blob: 040c8a4943193da7b3b1edce3a1846754dae397a (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
#!/bin/sh

# This script will write a dump file of local user state if you want to splat
# your entire server database and start again but preserve the identity of
# local users and their access tokens.
#
# To restore it, use
#
#   $ sqlite3 homeserver.db < table-save.sql

sqlite3 "$1" <<'EOF' >table-save.sql
.dump users
.dump access_tokens
.dump presence
.dump profiles
EOF