Differences

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

--- my_backup_pi_scripts [2016/08/04 19:14] – walkeradmin
+++ my_backup_pi_scripts [2023/03/09 22:35] (current) – external edit 127.0.0.1
@@ Line 11: / Line 11: @@
 \\
 \\
-===== Webserver1 Script =====
+===== Webserver1 Script (wikibackup) Latest =====
+<file>
+#!/bin/bash
+#
+# Script to backup webserver pi
+#
+#
+# Alan Walker - Nov 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 "Password" 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 "Password" 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 username -pPassword alan_gallery > /home/pi/Backups/webserver1/$(date '+%Y-%m-%d')/alan_gallery.sql
+#
+#
+echo ""
+echo "Finished"
+</file>
 \\
 \\
-    #!/bin/bash
+===== Wiki Server Backup Script (wikibackup) =====
-    #
+<file>
-    # Script to backup webserver and wiki pi's
+#!/bin/bash
-    #
+#
-    #
+# Script to backup wiki pi
-    # Alan Walker - Aug 2016
+#
-    #
+#
-    #
+# Alan Walker - Nov 2016
-    # stuff this script does
+#
-    # backup (rsync) cpg15x on webserver1
+#
-    # backup ShotLive on webserver1
+# stuff this script does
-    # backup (mysqldump) database on webserver1
+#
-    # backup wiki (rsync) on wiki pi
+# backup wiki (rsync) on wiki pi
-    #
+#
-    #
+#
-    # backup (rsync) cpg15x on webserver1
+# backup (rsync) wiki server
-    # create new backup folder
+# create new backup folder
-    echo "Creating folder /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d')
+echo "Creating folder /mnt/usbstorage/backups/wiki/"$(date '+%Y-%m-%d')
-    # make a folder with the current date
+# make a folder with the current date
-    mkdir /mnt/usbstorage/backups/webserver1/$(date '+%Y-%m-%d')
+mkdir /home/pi/Backups/wiki/$(date '+%Y-%m-%d')
-    #
+#
-    #
+# copy files from /home/pi/dokuwiki on wiki server to this server
-    # copy files from cpg15x on webserver to this server
+echo "Copying dokuwiki files to /home/pi/Backups/wiki/"$(date '+%Y-%m-%d')
-    echo "Copying cpg15x files to /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d')
+#
-    rsync -avzh pi@192.168.1.10:/home/pi/cpg15x /mnt/usbstorage/backups/webserver1/$(date '+%Y-%m-%d')
+#
-    #
+sudo sshpass -p "Password" rsync --super --verbose --recursive --perms --executability --acls --xattrs --owner --group  pi@192.168.1.9:/mnt/usbhdd/dokuwiki /home/pi/Backups/wiki/$(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')
+echo ""
-    rsync -avzh pi@192.168.1.10:/home/pi/ShotLive /mnt/usbstorage/backups/webserver1/$(date '+%Y-%m-%d')
+echo "Finished"
-    #
-    #
+</file>
-    # 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')
-    mysqldump --host 192.168.1.10 -P 3306 -u Username -pPassword alan_gallery > /mnt/usbstorage/backups/webserver1/$(date '+%Y-%m-%d')/alan_gallery.sql
-    #
-    #
-    echo ""
-    echo "Finished"
-    NOTE: The username and password have been removed from the SQL script
 \\
+===== Cron Automation =====
+To automate this process, I am using the following Cron job (use crontab -e)
 \\
+\\
+<file>
+# This job is to backup the webserver files and database at 3am every sunday
+3 * * 0 /mnt/usbstorage/backups/scripts/websvr1backup
+#
+#
+# This job is to backup the wiki server every sunday at 2am
+2 * * 0 /mnt/usbstorage/backups/scripts/wikibackup
+</file>
+\\
+\\