Index: /trunk/tools/mysql-dump/gpc1_dump.sh
===================================================================
--- /trunk/tools/mysql-dump/gpc1_dump.sh	(revision 31193)
+++ /trunk/tools/mysql-dump/gpc1_dump.sh	(revision 31193)
@@ -0,0 +1,41 @@
+#!/bin/bash
+
+# This script was originally on ipp001
+# I changed it a bit
+
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+. /home/panstarrs/ipp/mysql-dump/password.sh
+
+HOST=ippc02
+
+log INFO "Starting gpc1 dump"
+
+DUMP_PATH=/export/$HOST.0/mysql-dumps                  #path
+
+log INFO "Deleting old dumps"
+for file in `find $DUMP_PATH -name mysql-gpc1-$HOST-\*.dump.gz`; do
+	log INFO "Deleting $file"
+	/bin/rm -f $file
+done
+
+DATEVAR=`date +%FT%T`                                   #date        
+FILENAME=$DUMP_PATH/mysql-gpc1-$HOST-$DATEVAR.dump.gz    #dump file name
+DB_USERNAME=gpc1_dump
+MD5FILENAME=$DUMP_PATH/gpc1_checksum.md5
+
+log INFO "Deleting old md5 sum file"
+/bin/rm -f $MD5FILENAME
+
+log INFO "Dumping"
+/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction gpc1 | gzip -9 > $FILENAME
+dump_status=${PIPESTATUS[0]}
+if [ "$dump_status" -ne "0" ]; then
+	log ERROR "Sending warning e-mail"
+	email "Gpc1 dump failed" schastel@ifa.hawaii.edu "Check log file: /export/$HOST.0/mysql-dumps/gpc1_dump.log"
+	log INFO "End of gpc1 dump (Error)"
+	exit 1
+fi
+
+/usr/bin/md5sum $FILENAME > $MD5FILENAME
+log INFO "End of gpc1 dump (Success)"
+