Changeset 31253 for branches/czw_branch/20110406/tools/mysql-dump/ops_dump.csh

Timestamp:

Apr 8, 2011, 6:31:08 PM (15 years ago)

Author:

watersc1

Message:

merge from trunk

Location:

branches/czw_branch/20110406

Files:

• . (modified) (1 prop)
• tools/mysql-dump (modified) (1 prop)
• tools/mysql-dump/ops_dump.csh (modified) (5 diffs)

branches/czw_branch/20110406/tools/mysql-dump

@@ -1 +1 @@
 password.sh
+*.log
+.curr_gpc1_name

@@ -1 +1 @@
 password.sh
+*.log
+.curr_gpc1_name

branches/czw_branch/20110406/tools/mysql-dump/ops_dump.csh

@@ -2 +2 @@
 
 echo "## `/bin/date +%FT%T`"
+
+set EMAILTO = schastel@ifa.hawaii.edu
 
 # dump ippRequestServer from ippc19
@@ -7 +9 @@
 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
+   /bin/mail -s "Warning ippRequestServer/RS dump failed" $EMAILTO < msg
 endif
 
@@ -16 +18 @@
 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  
+   /bin/mail -s "Warning ippadmin dump failed" $EMAILTO < msg  
 endif
 
@@ -31 +33 @@
 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  
+   /bin/mail -s "Warning isp dump failed" $EMAILTO < msg  
 endif
 
@@ -39 +41 @@
 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
-

@@ -1 +1 @@
 password.sh
+*.log
+.curr_gpc1_name