Changeset 33415 for branches/meh_branches/ppstack_test/tools/mysql-dump/ops_dump.csh

Timestamp:

Mar 5, 2012, 5:19:48 PM (14 years ago)

Author:

mhuber

Message:

merging latest r33407 trunk changes to meh_branches/ppstack_test

Location:

branches/meh_branches/ppstack_test

Files:

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

branches/meh_branches/ppstack_test/tools/mysql-dump/ops_dump.csh

@@ -33 +33 @@
 set DATEVAR=`date +%FT%T`                                    #date
 set FILENAME = $DUMP_PATH/mysql-isp-ipp001-$DATEVAR.dump.bz
-mysqldump --compress -hipp001 -uipp -pipp --flush-logs --single-transaction isp | bzip2 > $FILENAME
+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  
+endif
+
+################################## ssp ##############################################
+# dump ssp from ippdb01
+set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps               #path(SAB)
+set DATEVAR=`date +%FT%T`                                    #date
+set FILENAME = $DUMP_PATH/mysql-ssp-ipp001-$DATEVAR.dump.bz
+mysqldump --compress -hippdb01 -uipp -pipp --flush-logs --single-transaction ssp | bzip2 > $FILENAME
+if ($status != 0) then
+   /bin/mail -s "Warning ssp dump failed" $EMAILTO < msg
 endif