Changeset 31434 for branches/czw_branch/20110406/tools/mysql-dump/neb_dump.sh

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/neb_dump.sh (modified) (3 diffs)

branches/czw_branch/20110406/tools/mysql-dump/neb_dump.sh

@@ -12 +12 @@
 . /home/panstarrs/ipp/mysql-dump/password.sh
 
-EMAILTO=schastel@ifa.hawaii.edu
+EMAILTO=ps-ipp-ops@ifa.hawaii.edu
+
 HOST=ippdb02
 
@@ -20 +21 @@
 
 log INFO "Deleting old dumps"
-for file in `find $DUMP_PATH -name mysql-neb-$HOST-\*.dump.gz`; do
+for file in `find $DUMP_PATH -name mysql-neb-$HOST-\*.dump.bz`; do
         log INFO "Deleting $file"
         /bin/rm -f $file
 done
 DATEVAR=`date +%FT%T`                                   #date        
-FILENAME=$DUMP_PATH/mysql-neb-$HOST-$DATEVAR.dump.gz    #dump file name
+FILENAME=$DUMP_PATH/mysql-neb-$HOST-$DATEVAR.dump.bz    #dump file name
 DB_USERNAME=neb_dump
 MD5FILENAME=$DUMP_PATH/neb_checksum.md5
@@ -33 +34 @@
 
 log INFO "Dumping to [$FILENAME]"
-/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction nebulous | gzip -9 > $FILENAME
+/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction nebulous | ~ipp/local/bin/pbzip2 > $FILENAME
 dump_status=${PIPESTATUS[0]}
 if [ "$dump_status" -ne "0" ]; then