Changeset 31434 for branches/czw_branch/20110406/tools/mysql-dump/gpc1_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/gpc1_dump.sh (modified) (4 diffs)

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

@@ -8 +8 @@
 #       - it deletes the old MySQL dumps
 #       - it deletes the old MD5 checksum file
-# 2) It calls mysqldump to dump gpc1 to some gzipped file
+# 2) It calls mysqldump to dump gpc1 to some bzipped file
 # 3) It computes the checksum
 # 4) It copies the dump and the checksum files onto the TARGET_HOST
@@ -16 +16 @@
 . /home/panstarrs/ipp/mysql-dump/password.sh
 
-EMAILTO=schastel@ifa.hawaii.edu
+EMAILTO=ps-ipp-ops@ifa.hawaii.edu
 
 HOST=ippc02
@@ -28 +28 @@
 #1) Cleaning
 log INFO "Deleting old dumps"
-for file in `find $DUMP_PATH -name mysql-gpc1-$HOST-\*.dump.gz`; do
+for file in `find $DUMP_PATH -name mysql-gpc1-$HOST-\*.dump.bz`; do
         log INFO "Deleting $file"
         /bin/rm -f $file
@@ -37 +37 @@
 #2) Dumping
 DATEVAR=`date +%FT%T`                                   #date        
-FILENAME=$DUMP_PATH/mysql-gpc1-$HOST-$DATEVAR.dump.gz    #dump file name
+FILENAME=$DUMP_PATH/mysql-gpc1-$HOST-$DATEVAR.dump.bz    #dump file name
 DB_USERNAME=gpc1_dump
 MD5FILENAME=$DUMP_PATH/gpc1_checksum.md5
 log INFO "Dumping to $FILENAME"
-/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction gpc1 | gzip -9 > $FILENAME
+/usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction gpc1 | ~ipp/local/bin/pbzip2 > $FILENAME
 dump_status=${PIPESTATUS[0]}
 if [ "$dump_status" -ne "0" ]; then