Index: trunk/tools/mysql-dump/neb_copy.sh
===================================================================
--- trunk/tools/mysql-dump/neb_copy.sh	(revision 31191)
+++ trunk/tools/mysql-dump/neb_copy.sh	(revision 31191)
@@ -0,0 +1,69 @@
+#!/bin/bash
+
+# This script is supposed to be executed on ipp001
+
+. /home/panstarrs/ipp/mysql-dump/functions.sh
+
+SOURCE_HOST=ippdb02
+HOST=ipp001
+
+SOURCE=ipp@$SOURCE_HOST:/export/$SOURCE_HOST.0/mysql-dumps
+TARGET=/export/$HOST.0/ipp/mysql-dumps
+
+MD5FILE=neb_checksum.md5
+
+MAX_ITERATIONS=200
+SLEEPING_TIME=60
+
+MD5_COPY_STATUS=1
+ITERATION=1
+while [ "$MD5_COPY_STATUS" -ne "0" ]; do
+	/usr/bin/scp -q $SOURCE/$MD5FILE $TARGET 2> /dev/null
+	MD5_COPY_STATUS=$?
+	if [ "$MD5_COPY_STATUS" -ne "0" ]; then
+		log WARNING "MD5 file not found on $SOURCE_HOST. Waiting $SLEEPING_TIME seconds (Attempt: $ITERATION out of $MAX_ITERATIONS)"
+#		echo "`date`: MD5 file not found on $SOURCE_HOST. Waiting $SLEEPING_TIME seconds (Attempt: $ITERATION out of $MAX_ITERATIONS)"
+		sleep $SLEEPING_TIME
+	fi
+	let ITERATION=ITERATION+1
+	if [ "$ITERATION" -ge "$MAX_ITERATIONS" ]; then
+                log ERROR "Copy of $SOURCE/$MD5FILE failed after $ITERATION iterations. Giving up"
+#		echo "`date`: Copy of $SOURCE/$MD5FILE failed after $ITERATION iterations. Giving up"
+		exit 1
+	fi
+done
+
+#echo "`date`: MD5 file successfully copied ($TARGET/$MD5FILE)"
+log INFO "MD5 file successfully copied ($TARGET/$MD5FILE)"
+
+EXPECTED_MD5SUM=`cat $TARGET/$MD5FILE | sed 's/ .*$//'`
+FILE_TO_COPY=`cat $TARGET/$MD5FILE | sed 's/^.* \//\//'`
+FILE_TO_COPY=`basename $FILE_TO_COPY`
+
+log INFO "Copying [$FILE_TO_COPY] now (expected MD5 sum: [$EXPECTED_MD5SUM])"
+#echo "Copying [$FILE_TO_COPY] now (expected MD5 sum: [$EXPECTED_MD5SUM])"
+/usr/bin/scp -q $SOURCE/$FILE_TO_COPY $TARGET > /dev/null
+if [ "$?" -ne "0" ]; then
+	log ERROR "Can't copy nebulous backup file [$FILE_TO_COPY]"
+#	echo "`date`: Can't copy nebulous backup file [$FILE_TO_COPY]"
+	exit 2
+else
+	log INFO "Nebulous backup file [$FILE_TO_COPY] successfully copied"
+#	echo "`date`: Nebulous backup file [$FILE_TO_COPY] successfully copied"
+fi
+
+log INFO "Checking nebulous backup file now"
+#echo "`date`: Checking nebulous backup file now"
+ACTUAL_MD5SUM=`/usr/bin/md5sum $TARGET/$FILE_TO_COPY | sed 's/ .*$//'`
+
+if [ "$ACTUAL_MD5SUM" != "$EXPECTED_MD5SUM" ]; then
+	log ERROR "Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+	#echo "`date`: Checksums are different: actual=[$ACTUAL_MD5SUM], expected=[$EXPECTED_MD5SUM]"
+	exit 3
+fi
+
+log INFO "Successfully done with [$TARGET/$FILE_TO_COPY]"
+#echo "`date`: Successfully done with [$TARGET/$FILE_TO_COPY]"
+
+exit 0
+