Add database-prepare-for-0.0.1.sh that should be run before starting a v0.0.1 homeserver.

1 files changed, 19 insertions, 0 deletions

diff --git a/database-prepare-for-0.0.1.sh b/database-prepare-for-0.0.1.sh
new file mode 100755
index 0000000000..17c0c5f34e
--- /dev/null
+++ b/database-prepare-for-0.0.1.sh
@@ -0,0 +1,19 @@
+#!/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.
+
+cp "$1" "$1.bak"
+
+DUMP=$(sqlite3 "$1" << 'EOF'
+.dump users
+.dump access_tokens
+.dump presence
+.dump profiles
+EOF
+)
+
+rm "$1"
+
+sqlite3 "$1" <<< "$DUMP"