Changeset 31866
- Timestamp:
- Jul 12, 2011, 9:49:53 AM (15 years ago)
- File:
-
- 1 edited
-
trunk/tools/mysql-dump/ops_dump.csh (modified) (4 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/tools/mysql-dump/ops_dump.csh
r31321 r31866 5 5 set EMAILTO = ps-ipp-ops@ifa.hawaii.edu 6 6 7 ################################## ippRequestServer ############################################## 7 8 # dump ippRequestServer from ippc19 8 9 set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB) … … 12 13 endif 13 14 15 ################################## ippadmin ############################################## 14 16 # dump ippadmin from ippdb01 15 17 set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB) 16 18 set DATEVAR=`date +%FT%T` #date 17 set FILENAME = $DUMP_PATH/mysql-ippadmin-ipp db01-$DATEVAR.dump.bz18 mysqldump --compress -hipp db01 -uipp -pipp --flush-logs --single-transaction ippadmin | bzip2 > $FILENAME19 set FILENAME = $DUMP_PATH/mysql-ippadmin-ipp001-$DATEVAR.dump.bz 20 mysqldump --compress -hipp001 -uipp -pipp --flush-logs --single-transaction ippadmin | bzip2 > $FILENAME 19 21 if ($status != 0) then 20 22 /bin/mail -s "Warning ippadmin dump failed" $EMAILTO < msg … … 24 26 set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB) 25 27 cd $DUMP_PATH/distribution/ #link dir 26 ln -f ../mysql-ippadmin-ipp db01-$DATEVAR.dump.bz ippdb01-ippadmin.dump.bz28 ln -f ../mysql-ippadmin-ipp001-$DATEVAR.dump.bz ippdb01-ippadmin.dump.bz 27 29 28 30 ################################## isp ############################################## 29 31 # dump isp from ippdb01 30 32 set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB) 31 33 set DATEVAR=`date +%FT%T` #date 32 set FILENAME = $DUMP_PATH/mysql-isp-ipp db01-$DATEVAR.dump.bz33 mysqldump --compress -hipp db01 -uipp -pipp --flush-logs --single-transaction isp | bzip2 > $FILENAME34 set FILENAME = $DUMP_PATH/mysql-isp-ipp001-$DATEVAR.dump.bz 35 mysqldump --compress -hipp001 -uipp -pipp --flush-logs --single-transaction isp | bzip2 > $FILENAME 34 36 if ($status != 0) then 35 37 /bin/mail -s "Warning isp dump failed" $EMAILTO < msg … … 39 41 set DUMP_PATH = /data/ipp001.0/ipp/mysql-dumps #path(SAB) 40 42 cd $DUMP_PATH/distribution/ #link dir 41 ln -f ../mysql-isp-ipp db01-$DATEVAR.dump.bz ippdb01-isp.dump.bz43 ln -f ../mysql-isp-ipp001-$DATEVAR.dump.bz ippdb01-isp.dump.bz 42 44
Note:
See TracChangeset
for help on using the changeset viewer.
