Changeset 31213

Timestamp:

Apr 6, 2011, 4:54:54 PM (15 years ago)

Author:

Serge CHASTEL

Message:

Documentation

File:

• trunk/tools/mysql-dump/neb_dump.sh (modified) (4 diffs)

trunk/tools/mysql-dump/neb_dump.sh

@@ -1 +1 @@
 #!/bin/bash
 
-# This script was originally on ipp001
-# I changed it a bit
+# This script is inspired by ops_dump.csh. It was originally run on ipp001.
+#
+# This is the script that performs nebulous databases dumps. It can be run on any
+# server hosting the nebulous database. Its main steps are:
+# 1) Clean the old dump and the old MD5 checksum files
+# 2) Dump the nebulous database
+# 3) Computes the MD5 checksum
 
 . /home/panstarrs/ipp/mysql-dump/functions.sh
@@ -10 +15 @@
 
 log INFO "Starting nebulous dump"
-#echo "`date`: Starting nebulous dump"
 
 DUMP_PATH=/export/$HOST.0/mysql-dumps                  #path
 
 log INFO "Deleting old dumps"
-#echo "`date`:  Deleting old dumps"
 for file in `find $DUMP_PATH -name mysql-neb-$HOST-\*.dump.gz`; do
         log INFO "Deleting $file"
-#       echo "`date`:  Deleting $file"
         /bin/rm -f $file
 done
-
 DATEVAR=`date +%FT%T`                                   #date        
 FILENAME=$DUMP_PATH/mysql-neb-$HOST-$DATEVAR.dump.gz    #dump file name
@@ -28 +29 @@
 
 log INFO "Deleting old md5 sum file"
-#echo "`date`:  Deleting old md5 sum"
 /bin/rm -f $MD5FILENAME
 
-log INFO "Dumping"
-#echo "`date`:  Dumping"
+log INFO "Dumping to [$FILENAME]"
 /usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction nebulous | gzip -9 > $FILENAME
 dump_status=${PIPESTATUS[0]}
 if [ "$dump_status" -ne "0" ]; then
         log ERROR "Sending warning e-mail"
-#       echo "`date`:  ERROR / Sending warning e-mail"
         email "Nebulous dump failed" schastel@ifa.hawaii.edu "Check log file: /export/ippdb02.0/mysql-dumps/neb-dump.log"
         log INFO "End of nebulous dump (Error)"
-#       echo "`date`: End of nebulous dump (Error)"
         exit 1
 fi
@@ -46 +43 @@
 /usr/bin/md5sum $FILENAME > $MD5FILENAME
 log INFO "End of nebulous dump (Success)"
-#echo "`date`: End of nebulous dump"