Changeset 31208

Timestamp:

Apr 6, 2011, 3:39:20 PM (15 years ago)

Author:

Serge CHASTEL

Message:

The dump script is also responsible of the copy of the files

File:

• trunk/tools/mysql-dump/gpc1_dump.sh (modified) (3 diffs)

trunk/tools/mysql-dump/gpc1_dump.sh

@@ -8 +8 @@
 
 HOST=ippc02
+TARGET_HOST=ipp0012
+TARGET_DIR=/export/ipp001.0/ipp/mysql-dumps/
 
-log INFO "Starting gpc1 dump"
+log INFO "Starting gpc1 backup"
 
 DUMP_PATH=/export/$HOST.0/mysql-dumps                  #path
@@ -27 +29 @@
 /bin/rm -f $MD5FILENAME
 
-log INFO "Dumping"
+log INFO "Dumping to $FILENAME"
 /usr/bin/mysqldump -h localhost -u $DB_USERNAME -p$DB_PASSWORD --flush-logs --single-transaction gpc1 | gzip -9 > $FILENAME
 dump_status=${PIPESTATUS[0]}
@@ -37 +39 @@
 fi
 
+log INFO "Generating MD5 checksum"
 /usr/bin/md5sum $FILENAME > $MD5FILENAME
 log INFO "End of gpc1 dump (Success)"
 
+log INFO "Copying $FILENAME on $TARGET_HOST"
+sudo -u ipp /usr/bin/scp -q $FILENAME ipp@$TARGET_HOST:$TARGET_DIR
+
+log INFO "Copying MD5 checksum file to $TARGET_HOST"
+sudo -u ipp /usr/bin/scp -q $MD5FILENAME ipp@$TARGET_HOST:$TARGET_DIR
+
+log INFO "End of gpc1 backup (Success)"
+