Index: trunk/tools/mysql-dump/gpc1Import.py
===================================================================
--- trunk/tools/mysql-dump/gpc1Import.py	(revision 31209)
+++ trunk/tools/mysql-dump/gpc1Import.py	(revision 31209)
@@ -0,0 +1,24 @@
+#!/usr/bin/python
+
+import commands
+filename='/netdisks/panstarrs/ipp/mysql-dump/.curr_gpc1_name'
+f=open(filename, 'r+')
+currname=f.read()
+f.close()
+
+if(currname=='gpc1_0'):
+	newname='gpc1_1'
+else:
+	newname='gpc1_0'
+
+print newname
+gpc1dumps=commands.getoutput('ls -t -1 /export/ipp001.0/ipp/mysql-dumps/mysql-gpc1*')
+dumparray=gpc1dumps.split()[1]
+cmd='gunzip < '+dumparray+' | mysql -hipp001 -u ipp -pipp -f ' + newname
+results = commands.getstatusoutput(cmd)
+
+f=open(filename, 'w')
+f.write(newname)
+f.close()
+
+print results
Index: trunk/tools/mysql-dump/gpc1_install.sh
===================================================================
--- trunk/tools/mysql-dump/gpc1_install.sh	(revision 31209)
+++ trunk/tools/mysql-dump/gpc1_install.sh	(revision 31209)
@@ -0,0 +1,44 @@
+#!/bin/bash
+
+# This script is supposed to be executed on ipp001
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+
+HOST=ipp001
+TARGET=/export/$HOST.0/ipp/mysql-dumps
+MD5FILE=gpc1_checksum.md5
+
+DISTRIBUTION_TARGET=$TARGET/distribution/ippdb01-gpc1.dump.gz
+
+MAX_ITERATIONS=200
+SLEEPING_TIME=60
+
+log INFO "Starting installation of gpc1"
+
+ITERATION=1
+if [ ! -s $TARGET/$MD5FILE ]; then
+	log WARNING "MD5 file not found [$TARGET/$MD5FILE]. Waiting $SLEEPING_TIME seconds (Attempt: $ITERATION out of $MAX_ITERATIONS)"
+	sleep $SLEEPING_TIME
+	let ITERATION=ITERATION+1
+	if [ "$ITERATION" -ge "$MAX_ITERATIONS" ]; then
+		log ERROR "Copy of $TARGET/$MD5FILE failed after $ITERATION iterations. Giving up"
+		exit 1
+	fi
+fi
+
+log INFO "Checking gpc1 backup file checksum"
+EXPECTED_MD5SUM=`cat $TARGET/$MD5FILE | sed 's/ .*$//'`
+BACKUP_FILE=`cat $TARGET/$MD5FILE | sed 's/^.* \//\//'`
+BACKUP_FILE=`basename $BACKUP_FILE`
+
+ACTUAL_MD5SUM=`/usr/bin/md5sum $TARGET/$BACKUP_FILE | sed 's/ .*$//'`
+if [ "$ACTUAL_MD5SUM" != "$EXPECTED_MD5SUM" ]; then
+        log ERROR "Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+        exit 2
+fi
+
+log INFO "Importing gpc1 backup file to gpc1_0 or gpc1_1"
+/usr/bin/python /home/panstarrs/ipp/mysql-dump/gpc1Import.py
+
+log INFO "Symlinking backup file [$TARGET/$BACKUP_FILE] to distribution [$DISTRIBUTION_TARGET]"
+/usr/bin/ln -f $TARGET/$BACKUP_FILE $DISTRIBUTION_TARGET
+
Index: trunk/tools/mysql-dump/ops_dump.csh
===================================================================
--- trunk/tools/mysql-dump/ops_dump.csh	(revision 31209)
+++ trunk/tools/mysql-dump/ops_dump.csh	(revision 31209)
@@ -0,0 +1,78 @@
+#!/bin/csh
+
+echo "## `/bin/date +%FT%T`"
+
+# dump ippRequestServer from ippc19
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps       #path(SAB)
+mysqldump --compress -hippc19 -uipp -pipp --flush-logs --single-transaction --log-error=RS-err ippRequestServer | gzip -9 > $DUMP_PATH/mysql-RS-ippc19-`date +%FT%T`.dump.gz
+if ($status != 0) then
+   /bin/mail -s "Warning RS dump failed" schastel@ifa.hawaii.edu < msg
+endif
+
+# dump ippadmin from ippdb01
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps               #path(SAB)
+set DATEVAR=`date +%FT%T`                                    #date
+set FILENAME = $DUMP_PATH/mysql-ippadmin-ippdb01-$DATEVAR.dump.gz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction ippadmin | gzip -9 > $FILENAME
+if ($status != 0) then
+   /bin/mail -s "Warning ippadmin dump failed" schastel@ifa.hawaii.edu < msg  
+endif
+
+# simlink to ippadmin ippdb01 dump
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps       #path(SAB)
+cd $DUMP_PATH/distribution/                          #link dir
+ln -f  ../mysql-ippadmin-ippdb01-$DATEVAR.dump.gz ippdb01-ippadmin.dump.gz
+
+
+# dump isp from ippdb01
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps               #path(SAB)
+set DATEVAR=`date +%FT%T`                                    #date
+set FILENAME = $DUMP_PATH/mysql-isp-ippdb01-$DATEVAR.dump.gz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction isp | gzip -9 > $FILENAME
+if ($status != 0) then
+   /bin/mail -s "Warning isp dump failed" schastel@ifa.hawaii.edu < msg  
+endif
+
+# simlink to isp ippdb01 dump
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps       #path(SAB)
+cd $DUMP_PATH/distribution/                          #link dir
+ln -f  ../mysql-isp-ippdb01-$DATEVAR.dump.gz ippdb01-isp.dump.gz
+
+# dump gpc1 from ippdb01
+#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps               #path(SAB)
+#set DATEVAR=`date +%FT%T`                                    #date
+#set FILENAME = $DUMP_PATH/mysql-gpc1-ippc02-$DATEVAR.dump.gz #dump file name
+#mysqldump --compress -hippc -P3302 -uipp -pipp --flush-logs --single-transaction gpc1 | gzip -9 > $FILENAME
+#if ($status != 0) then
+#   /bin/mail -s "Warning gpc1 dump failed" schastel@ifa.hawaii.edu < msg  
+#endif
+
+# simlink to gpc1 ippdb01 dump
+#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps       #path(SAB)
+#cd $DUMP_PATH/distribution/                          #link dir
+#ln -f  ../mysql-gpc1-ippc02-$DATEVAR.dump.gz ippdb01-gpc1.dump.gz   #hard link
+
+
+# dump the ippdb02 database
+#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps             #path
+#set DATEVAR = `date +%FT%T`                                #date	
+#set FILENAME = $DUMP_PATH/mysql-neb-ippdb02-$DATEVAR.dump.gz   #dump file name
+#mysqldump --compress -hippdb02 -ujhipp -pjhipp --flush-logs --single-transaction nebulous | gzip -9 > $FILENAME
+#if ($status != 0) then
+#   /bin/mail -s "Warning nebulous dump failed" schastel@ifa.hawaii.edu < msg  
+#endif
+
+# simlink to latest ippdb02 dump
+#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps	           #path (SAB)
+#cd $DUMP_PATH/distribution/                                #link dir
+#ln -f  ../mysql-neb-ippdb02-$DATEVAR.dump.gz ippdb02.dump.gz   #hard link
+
+# dump the ippdb00 database
+#set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps             #path
+#set DATEVAR = `date +%FT%T`                                #date	
+#set FILENAME = $DUMP_PATH/mysql-neb-ippdb00-$DATEVAR.dump.gz   #dump file name
+#mysqldump --compress -hippdb00 -ujhipp -pjhipp --flush-logs --single-transaction nebulous | gzip -9 > $FILENAME
+#if ($status != 0) then
+#   /bin/mail -s "Warning nebulous dump failed" schastel@ifa.hawaii.edu < msg  
+#endif
+