Differences

This shows you the differences between two versions of the page.

--- my_backup_pi_scripts [2016/11/06 17:49] – [Webserver1 Script (wevsvr1backup)] walkeradmin
+++ my_backup_pi_scripts [2016/11/06 17:51] – walkeradmin
@@ Line 11: / Line 11: @@
 \\
 \\
-===== Webserver1 Script (wevsvr1backup) =====
+===== Webserver1 Script (wevsvr1backup) Latest =====
+<file>
+#!/bin/bash
+#
+# Script to backup webserver pi
+#
+#
+# Alan Walker - Aug 2016
+#
+#
+# stuff this script does
+# backup (rsync) cpg15x on webserver1
+# backup ShotLive on webserver1
+# backup (mysqldump) database on webserver1
+#
+#
+# backup (rsync) cpg15x on webserver1
+# create new backup folder
+echo "Creating folder /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d')
+# make a folder with the current date
+mkdir /home/pi/Backups/webserver1/$(date '+%Y-%m-%d')
+#
+#
+# copy files from cpg15x on webserver to this server
+echo "Copying cpg15x files to /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d')
+sudo sshpass -p "Cr00kh0rn52.." rsync --verbose --recursive --perms --executability --acls --xattrs --owner --group  pi@192.168.1.9:/mnt/usbhdd/cpg15x /home/pi/Backups/webserver1/$(date '+%Y-%m-%d')
+#
+#
+# copy files from ShotLive on webserver to this server
+echo "Copying ShotLive files to /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d')
+#sudo rsync --verbose --recursive --perms --executability --acls --xattrs --owner --group  pi@192.168.1.10:/home/pi/ShotLive /mnt/usbstorage/backups/webserver1/$(date '+%Y-%m-%d')
+sudo sshpass -p "Cr00kh0rn52.." rsync --verbose --recursive --perms --executability --acls --xattrs --owner --group  pi@192.168.1.9:/mnt/usbhdd/ShotLive /home/pi/Backups/webserver1/$(date '+%Y-%m-%d')
+#
+#
+# Backup MySQL Database (the one database is used for both ShotLive and Cameraangle)
+echo "Backup database to /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d')
+sudo mysqldump --host 192.168.1.9 -P 3306 -u walkeradmin -pCr00kh0rn52.. alan_gallery > /home/pi/Backups/webserver1/$(date '+%Y-%m-%d')/alan_gallery.sql
+#
+#mysqldump --host 192.168.1.9 -P 3306 -u username -pPassword alan_gallery > /mnt/usbstorage/backups/webserver1/$(date '+%Y-%m-%d')/alan_gallery.sql
+#
+#
+echo ""
+echo "Finished"
+</file>
+\\
+\\
+===== Webserver1 Script (wevsvr1backup) Original =====
     #!/bin/bash
     #