my_backup_pi_scripts
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revisionNext revisionBoth sides next revision | ||
| my_backup_pi_scripts [2016/08/04 19:13] – created walkeradmin | my_backup_pi_scripts [2016/11/06 17:51] – walkeradmin | ||
|---|---|---|---|
| Line 11: | Line 11: | ||
| \\ | \\ | ||
| \\ | \\ | ||
| - | ===== Webserver1 Script ===== | + | ===== Webserver1 Script |
| + | < | ||
| + | # | ||
| + | # | ||
| + | # 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 " | ||
| + | # make a folder with the current date | ||
| + | mkdir / | ||
| + | # | ||
| + | # | ||
| + | # copy files from cpg15x on webserver to this server | ||
| + | echo " | ||
| + | sudo sshpass -p " | ||
| + | # | ||
| + | # | ||
| + | # copy files from ShotLive on webserver to this server | ||
| + | echo " | ||
| + | #sudo rsync --verbose --recursive --perms --executability --acls --xattrs --owner --group | ||
| + | sudo sshpass -p " | ||
| + | # | ||
| + | # | ||
| + | # Backup MySQL Database (the one database is used for both ShotLive and Cameraangle) | ||
| + | echo " | ||
| + | sudo mysqldump --host 192.168.1.9 -P 3306 -u walkeradmin -pCr00kh0rn52.. alan_gallery > / | ||
| + | # | ||
| + | #mysqldump --host 192.168.1.9 -P 3306 -u username -pPassword alan_gallery > / | ||
| + | # | ||
| + | # | ||
| + | echo "" | ||
| + | echo " | ||
| + | </ | ||
| \\ | \\ | ||
| \\ | \\ | ||
| + | ===== Webserver1 Script (wevsvr1backup) Original ===== | ||
| #!/bin/bash | #!/bin/bash | ||
| # | # | ||
| - | # Script to backup webserver | + | # Script to backup webserver pi |
| # | # | ||
| # | # | ||
| Line 26: | Line 70: | ||
| # backup ShotLive on webserver1 | # backup ShotLive on webserver1 | ||
| # backup (mysqldump) database on webserver1 | # backup (mysqldump) database on webserver1 | ||
| - | # backup wiki (rsync) on wiki pi | ||
| # | # | ||
| # | # | ||
| Line 48: | Line 91: | ||
| # 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 " | echo " | ||
| - | mysqldump --host 192.168.1.10 -P 3306 -u Username -pPassword alan_gallery | + | mysqldump --host 192.168.1.10 -P 3306 -u Username -pPassword alan_gallery > / |
| # | # | ||
| # | # | ||
| Line 58: | Line 101: | ||
| \\ | \\ | ||
| \\ | \\ | ||
| + | ===== Wiki Server Backup Script (wikibackup) ===== | ||
| + | #!/bin/bash | ||
| + | # | ||
| + | # Script to backup wiki pi | ||
| + | # | ||
| + | # | ||
| + | # Alan Walker - Aug 2016 | ||
| + | # | ||
| + | # | ||
| + | # stuff this script does | ||
| + | # | ||
| + | # backup wiki (rsync) on wiki pi | ||
| + | # | ||
| + | # | ||
| + | # backup (rsync) wiki server | ||
| + | # create new backup folder | ||
| + | echo " | ||
| + | # make a folder with the current date | ||
| + | mkdir / | ||
| + | # | ||
| + | # | ||
| + | # copy files from / | ||
| + | echo " | ||
| + | rsync -avzh pi@192.168.1.11:/ | ||
| + | # | ||
| + | # | ||
| + | echo "" | ||
| + | echo " | ||
| + | \\ | ||
| + | \\ | ||
| + | ===== Cron Automation ===== | ||
| + | To automate this process, I am using the following Cron job (use sudo Crontab -e) | ||
| + | \\ | ||
| + | \\ | ||
| + | # Edit this file to introduce tasks to be run by cron. | ||
| + | # | ||
| + | # Each task to run has to be defined through a single line | ||
| + | # indicating with different fields when the task will be run | ||
| + | # and what command to run for the task | ||
| + | # | ||
| + | # To define the time you can provide concrete values for | ||
| + | # minute (m), hour (h), day of month (dom), month (mon), | ||
| + | # and day of week (dow) or use ' | ||
| + | # Notice that tasks will be started based on the cron's system | ||
| + | # daemon' | ||
| + | # | ||
| + | # 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 / | ||
| + | # | ||
| + | # For more information see the manual pages of crontab(5) and cron(8) | ||
| + | # | ||
| + | # m h dom mon dow | ||
| + | # | ||
| + | # | ||
| + | # This job is to backup the webserver files and database at 3am every sunday | ||
| + | 00 03 * * 0 / | ||
| + | # | ||
| + | # | ||
| + | # This job is to backup the wiki server every sunday at 3am | ||
| + | 00 02 * * 0 / | ||
| + | \\ | ||
| + | \\ | ||
| + | |||
| + | |||
| + | |||
| + | |||
my_backup_pi_scripts.txt · Last modified: 2023/03/09 22:35 by 127.0.0.1