summary refs log tree commit diff
path: root/scripts-dev/database-save.sh
diff options
context:
space:
mode:
authorMark Haines <mjark@negativecurvature.net>2015-05-06 12:54:07 +0100
committerMark Haines <mjark@negativecurvature.net>2015-05-06 12:54:07 +0100
commit3c11c9c122ec73c495bd691ba8608ad6a406b332 (patch)
tree8c9b339ce336b8d1dd45a3ac899c1875612236aa /scripts-dev/database-save.sh
parentMerge pull request #138 from matrix-org/erikj/SYN-371 (diff)
parentAcutally add scripts-dev/ (diff)
downloadsynapse-3c11c9c122ec73c495bd691ba8608ad6a406b332.tar.xz
Merge pull request #140 from matrix-org/erikj/scripts_refactor
Seperate scripts/ into scripts/ and scripts-dev/
Diffstat (limited to 'scripts-dev/database-save.sh')
-rwxr-xr-xscripts-dev/database-save.sh16
1 files changed, 16 insertions, 0 deletions
diff --git a/scripts-dev/database-save.sh b/scripts-dev/database-save.sh
new file mode 100755
index 0000000000..040c8a4943
--- /dev/null
+++ b/scripts-dev/database-save.sh
@@ -0,0 +1,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