WalkerWiki - wiki.alanwalker.uk

User Tools

Site Tools

Trace: • chown_examples • a_4_button_gui • debian_sudo_elevation • using_led_flash • interface_renaming_scripts • gpio_inputs_-_button_led_control • route_command • cron_logging • terraform_a_simple_aws_ec2_instance • adding_and_removing_linux_permissions
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
my_backup_pi_scripts [2016/08/04 18:21] – walkeradminmy_backup_pi_scripts [2016/11/06 18:39] (current) – [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 ===== ===== Cron Automation =====
-To automate this process, I am using the following Cron job (use sudo Crontab -e)+To automate this process, I am using the following Cron job (use crontab -e)
 \\  \\ 
 \\  \\ 
-    # Edit this file to introduce tasks to be run by cron. +<file> 
-    # +# This job is to backup the webserver files and database at 3am every sunday 
-    # Each task to run has to be defined through a single line +0 3 * * 0 /mnt/usbstorage/backups/scripts/websvr1backup 
-    # indicating with different fields when the task will be run +# 
-    # and what command to run for the task +# 
-    # +# This job is to backup the wiki server every sunday at 2am 
-    # To define the time you can provide concrete values for +0 2 * * 0 /mnt/usbstorage/backups/scripts/wikibackup 
-    # minute (m), hour (h), day of month (dom), month (mon), +</file>
-    # and day of week (dow) or use '*' in these fields (for 'any').# +
-    # Notice that tasks will be started based on the cron's system +
-    # daemon's notion of time and timezones. +
-    # +
-    # Output of the crontab jobs (including errors) is sent through +
-    # email to the user the crontab file belongs to (unless redirected). +
-    # +
-    # For example, you can run a backup of all your user accounts +
-    # at 5 a.m every week with: +
-    # 0 5 * * 1 tar -zcf /var/backups/home.tgz /home/ +
-    # +
-    # For more information see the manual pages of crontab(5) and cron(8) +
-    # +
-    # m h  dom mon dow   command +
-    # +
-    # +
-    # This job is to backup the webserver files and database at 3am every sunday +
-    00 03 * * 0 /mnt/usbstorage/backups/scripts/websvr1backup | tee /mnt/usbstorage/backups/logs/$(date '+%Y-%m-%d')-websvr1backup.log +
-    # +
-    # +
-    # This job is to backup the wiki server every sunday at 3am +
-    00 02 * * 0 /mnt/usbstorage/backups/scripts/wikibackup | tee /mnt/usbstorage/backups/logs/$(date '+%Y-%m-%d')-wikiba$+
 \\  \\ 
 \\  \\ 
my_backup_pi_scripts.1470334895.txt.gz · Last modified: (external edit)