From b42cc773ed16e7cddf78a1525475329d430b1753 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@status.net>
Date: Sun, 16 Oct 2011 04:44:08 -0400
Subject: [PATCH] Script to move a statusnetwork from one db server to another

This script helps move a statusnetwork from one DB server to
another. It's for use with multi-site installations (like status.net).
---
 scripts/move_status_network.sh | 102 +++++++++++++++++++++++++++++++++
 1 file changed, 102 insertions(+)
 create mode 100755 scripts/move_status_network.sh

diff --git a/scripts/move_status_network.sh b/scripts/move_status_network.sh
new file mode 100755
index 0000000000..2a259c280a
--- /dev/null
+++ b/scripts/move_status_network.sh
@@ -0,0 +1,102 @@
+#!/bin/bash
+
+# live fast! die young!
+
+set -e
+
+# move_status_network.sh nickname newserver
+
+export nickname="$1"
+export newdbhost="$2"
+
+source /etc/statusnet/setup.cfg
+
+function set_maintenance_mode()
+{
+    local nickname=$1;
+
+    php $PHPBASE/scripts/settag.php $nickname maintenancemode;
+}
+
+function get_current_db_info()
+{
+    local nickname=$1;
+
+    #FIXME I couldn't make this work better
+    
+    export dbhost=`mysql -NB -h $SITEDBHOSTNAME -u $ADMIN --password=$ADMINPASS -e "SELECT dbhost FROM status_network WHERE nickname = '$nickname'" $SITEDB`
+    export dbuser=`mysql -NB -h $SITEDBHOSTNAME -u $ADMIN --password=$ADMINPASS -e "SELECT dbuser FROM status_network WHERE nickname = '$nickname'" $SITEDB`
+    export dbpass=`mysql -NB -h $SITEDBHOSTNAME -u $ADMIN --password=$ADMINPASS -e "SELECT dbpass FROM status_network WHERE nickname = '$nickname'" $SITEDB`
+    export dbname=`mysql -NB -h $SITEDBHOSTNAME -u $ADMIN --password=$ADMINPASS -e "SELECT dbname FROM status_network WHERE nickname = '$nickname'" $SITEDB`
+}
+
+function create_empty_db()
+{
+    local newdbhost=$1;
+    local dbuser=$2;
+    local dbpass=$3;
+    local dbname=$4;
+    
+    mysqladmin -h $newdbhost -u $ADMIN --password=$ADMINPASS create $dbname;
+    
+    mysql -h $newdbhost -u $ADMIN --password=$ADMINPASS -e "GRANT ALL ON $dbname.* TO '$dbuser'@'localhost' IDENTIFIED BY '$dbpass';" $dbname;
+    mysql -h $newdbhost -u $ADMIN --password=$ADMINPASS -e "GRANT ALL ON $dbname.* TO '$dbuser'@'%' IDENTIFIED BY '$dbpass';" $dbname;
+}
+
+function transfer_data()
+{
+    local dbhost=$1;
+    local newdbhost=$2;
+    local dbuser=$3;
+    local dbpass=$4;
+    local dbname=$5;
+    local dumpfile=`mktemp`;
+
+    mysqldump -h $dbhost -u $ADMIN --password=$ADMINPASS $dbname > $dumpfile;
+    mysql -h $newdbhost -u $ADMIN --password=$ADMINPASS $dbname < $dumpfile;
+    rm $dumpfile;
+}
+
+function update_routing_table()
+{
+    local nickname=$1;
+    local newdbhost=$2;
+    
+    mysql -h $SITEDBHOSTNAME -u $ADMIN --password=$ADMINPASS -e "UPDATE status_network set dbhost = '$newdbhost' where nickname = '$nickname'" $SITEDB
+}
+
+function flush_site()
+{
+    local nickname=$1;
+    
+    php $PHPBASE/scripts/flushsite.php -s$nickname.$WILDCARD
+}
+
+function unset_maintenance_mode()
+{
+    local nickname=$1;
+    
+    php $PHPBASE/scripts/settag.php -d $nickname maintenancemode;
+}
+
+echo -n Setting maintenance mode on $nickname...
+set_maintenance_mode $nickname
+echo DONE.
+echo -n Getting current database info...
+get_current_db_info $nickname
+echo DONE.
+echo -n Creating empty $dbname database on server $newdbhost...
+create_empty_db $newdbhost $dbuser $dbpass $dbname
+echo DONE
+echo -n Copying $dbname database from $dbhost to $newdbhost...
+transfer_data $dbhost $newdbhost $dbuser $dbpass $dbname
+echo DONE
+echo -n Updating the routing table for $nickname to use $dbname on $newdbhost...
+update_routing_table $nickname $newdbhost
+echo DONE
+echo -n Flushing $nickname site from cache...
+flush_site $nickname
+echo DONE
+echo -n Turning off maintenance mode on $nickname...
+unset_maintenance_mode $nickname
+echo DONE.
-- 
2.39.5