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

Timestamp:

May 4, 2011, 3:20:38 PM (15 years ago)

Author:

watersc1

Message:

Merging trunk into this branch

Location:

branches/czw_branch/20110406

Files:

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

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

@@ -3 +3 @@
 echo "## `/bin/date +%FT%T`"
 
-set EMAILTO = schastel@ifa.hawaii.edu
+set EMAILTO = ps-ipp-ops@ifa.hawaii.edu
 
 # 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
+mysqldump --compress -hippc19 -uipp -pipp --flush-logs --single-transaction --log-error=RS-err ippRequestServer | bzip2 > $DUMP_PATH/mysql-RS-ippc19-`date +%FT%T`.dump.bz
 if ($status != 0) then
    /bin/mail -s "Warning ippRequestServer/RS dump failed" $EMAILTO < msg
@@ -15 +15 @@
 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
+set FILENAME = $DUMP_PATH/mysql-ippadmin-ippdb01-$DATEVAR.dump.bz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction ippadmin | bzip2 > $FILENAME
 if ($status != 0) then
    /bin/mail -s "Warning ippadmin dump failed" $EMAILTO < msg  
@@ -24 +24 @@
 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
+ln -f  ../mysql-ippadmin-ippdb01-$DATEVAR.dump.bz ippdb01-ippadmin.dump.bz
 
 
@@ -30 +30 @@
 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
+set FILENAME = $DUMP_PATH/mysql-isp-ippdb01-$DATEVAR.dump.bz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction isp | bzip2 > $FILENAME
 if ($status != 0) then
    /bin/mail -s "Warning isp dump failed" $EMAILTO < msg  
@@ -39 +39 @@
 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
+ln -f  ../mysql-isp-ippdb01-$DATEVAR.dump.bz ippdb01-isp.dump.bz