Index: trunk/tools/mysql-dump/ops_dump.csh
===================================================================
--- trunk/tools/mysql-dump/ops_dump.csh	(revision 33069)
+++ trunk/tools/mysql-dump/ops_dump.csh	(revision 33195)
@@ -33,7 +33,17 @@
 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