1 files changed, 16 insertions, 0 deletions

diff --git a/database-save.sh b/database-save.sh
new file mode 100755

index 0000000000..c80f676f76
--- /dev/null
+++ b/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 homeserver.db <<'EOF' >table-save.sql
+.dump users
+.dump access_tokens
+.dump presence
+.dump profiles
+EOF