Changeset 33195 for trunk/tools/mysql-dump/ops_dump.csh

Timestamp:

Feb 1, 2012, 3:21:46 PM (14 years ago)

Author:

Serge CHASTEL

Message:

Added ssp. Changed isp dump host to ippdb01

File:

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

trunk/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