summary refs log tree commit diff
path: root/scripts/database-prepare-for-0.0.1.sh
blob: 43d759a5cdb1849305853b2d96bc76fd28b68fed (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
#!/bin/bash

# This is will prepare a synapse database for running with v0.0.1 of synapse. 
# It will store all the user information, but will *delete* all messages and
# room data.

set -e

cp "$1" "$1.bak"

DUMP=$(sqlite3 "$1" << 'EOF'
.dump users
.dump access_tokens
.dump presence
.dump profiles
EOF
)

rm "$1"

sqlite3 "$1" <<< "$DUMP"