WalkerWiki - wiki.alanwalker.uk

User Tools

Site Tools

Trace:
my_backup_pi_scripts

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
my_backup_pi_scripts [2016/08/04 19:17] – walkeradminmy_backup_pi_scripts [2016/11/06 18:39] – [Cron Automation] walkeradmin
Line 11: Line 11:
 \\  \\ 
 \\  \\ 
-===== Webserver1 Script (wevsvr1backup) ===== +===== Webserver1 Script (wikibackup) Latest ===== 
-    #!/bin/bash +<file> 
-    # +#!/bin/bash 
-    # Script to backup webserver pi +# 
-    # +# Script to backup webserver pi 
-    # +# 
-    # Alan Walker - Aug 2016 +# 
-    # +# Alan Walker - Nov 2016 
-    # +# 
-    # stuff this script does +# 
-    # backup (rsync) cpg15x on webserver1 +# stuff this script does 
-    # backup ShotLive on webserver1 +# backup (rsync) cpg15x on webserver1 
-    # backup (mysqldump) database on webserver1 +# backup ShotLive on webserver1 
-    # +# backup (mysqldump) database on webserver1 
-    # +# 
-    # backup (rsync) cpg15x on webserver1 +# 
-    # create new backup folder +# backup (rsync) cpg15x on webserver1 
-    echo "Creating folder /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d') +# create new backup folder 
-    # make a folder with the current date +echo "Creating folder /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d') 
-    mkdir /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 +# copy files from cpg15x on webserver to this server 
-    echo "Copying cpg15x files to /mnt/usbstorage/backups/webserver1/"$(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 --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 
-    # copy files from ShotLive on webserver to this server +echo "Copying ShotLive files to /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d') 
-    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') 
-    rsync -avzh 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) 
-    # 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') 
-    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 
-    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 "" +echo "Finished" 
-    echo "Finished" +</file>
-     +
-     +
-    NOTE: The username and password have been removed from the SQL script+
 \\  \\ 
 \\  \\ 
 ===== Wiki Server Backup Script (wikibackup) ===== ===== Wiki Server Backup Script (wikibackup) =====
-    #!/bin/bash +<file> 
-    # +#!/bin/bash 
-    # Script to backup wiki pi +# 
-    # +# Script to backup wiki pi 
-    # +# 
-    # Alan Walker - Aug 2016 +# 
-    # +# Alan Walker - Nov 2016 
-    # +# 
-    # stuff this script does +# 
-    # +# stuff this script does 
-    # backup wiki (rsync) on wiki pi +# 
-    # +# backup wiki (rsync) on wiki pi 
-    # +# 
-    # backup (rsync) wiki server +# 
-    # create new backup folder +# backup (rsync) wiki server 
-    echo "Creating folder /mnt/usbstorage/backups/wiki/"$(date '+%Y-%m-%d') +# create new backup folder 
-    # make a folder with the current date +echo "Creating folder /mnt/usbstorage/backups/wiki/"$(date '+%Y-%m-%d') 
-    mkdir /mnt/usbstorage/backups/wiki/$(date '+%Y-%m-%d') +# make a folder with the current date 
-    # +mkdir /home/pi/Backups/wiki/$(date '+%Y-%m-%d') 
-    # +# 
-    # copy files from /home/pi/dokuwiki on wiki server to this server +# copy files from /home/pi/dokuwiki on wiki server to this server 
-    echo "Copying dokuwiki files to /mnt/usbstorage/backups/webserver1/"$(date '+%Y-%m-%d') +echo "Copying dokuwiki files to /home/pi/Backups/wiki/"$(date '+%Y-%m-%d') 
-    rsync -avzh pi@192.168.1.11:/home/pi/dokuwiki /mnt/usbstorage/backups/wiki/$(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') 
-    echo "" +# 
-    echo "Finished"+# 
 +echo "" 
 +echo "Finished" 
 + 
 +</file>
 \\  \\ 
 +===== 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
 +0 3 * * 0 /mnt/usbstorage/backups/scripts/websvr1backup
 +#
 +#
 +# This job is to backup the wiki server every sunday at 2am
 +0 2 * * 0 /mnt/usbstorage/backups/scripts/wikibackup
 +</file>
 +\\ 
 +\\ 
 +
 +
 +
 +
  
  
my_backup_pi_scripts.txt · Last modified: 2023/03/09 22:35 by 127.0.0.1