my_backup_pi_scripts
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
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 |
+ | < | ||
+ | # | ||
+ | # | ||
+ | # 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 " | ||
+ | # 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 username -pPassword alan_gallery > / | ||
+ | # | ||
+ | # | ||
+ | echo "" | ||
+ | echo " | ||
+ | </ | ||
\\ | \\ | ||
- | #!/bin/bash | ||
- | # | ||
- | # Script to backup webserver and wiki pi's | ||
- | # | ||
- | # | ||
- | # Alan Walker - Aug 2016 | ||
- | # | ||
- | # | ||
- | # stuff this script does | ||
- | # backup (rsync) cpg15x on webserver1 | ||
- | # backup ShotLive on webserver1 | ||
- | # backup (mysqldump) database on webserver1 | ||
- | # backup wiki (rsync) on wiki pi | ||
- | # | ||
- | # | ||
- | # 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 " | ||
- | rsync -avzh pi@192.168.1.10:/ | ||
- | # | ||
- | # | ||
- | # copy files from ShotLive on webserver to this server | ||
- | echo " | ||
- | rsync -avzh pi@192.168.1.10:/ | ||
- | # | ||
- | # | ||
- | # Backup MySQL Database (the one database is used for both ShotLive and Cameraangle) | ||
- | echo " | ||
- | mysqldump --host 192.168.1.10 -P 3306 -u Username -pPassword alan_gallery > / | ||
- | # | ||
- | # | ||
- | echo "" | ||
- | echo " | ||
- | | ||
- | | ||
- | NOTE: The username and password have been removed from the SQL script | ||
\\ | \\ | ||
+ | ===== Wiki Server Backup Script (wikibackup) ===== | ||
+ | < | ||
+ | #!/bin/bash | ||
+ | # | ||
+ | # Script to backup wiki pi | ||
+ | # | ||
+ | # | ||
+ | # Alan Walker - Nov 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 " | ||
+ | # | ||
+ | # | ||
+ | sudo sshpass -p " | ||
+ | # | ||
+ | # | ||
+ | echo "" | ||
+ | echo " | ||
+ | |||
+ | </ | ||
\\ | \\ | ||
+ | ===== Cron Automation ===== | ||
+ | To automate this process, I am using the following Cron job (use crontab -e) | ||
+ | \\ | ||
+ | \\ | ||
+ | < | ||
+ | # This job is to backup the webserver files and database at 3am every sunday | ||
+ | 0 3 * * 0 / | ||
+ | # | ||
+ | # | ||
+ | # This job is to backup the wiki server every sunday at 2am | ||
+ | 0 2 * * 0 / | ||
+ | </ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | |||
+ | |||
+ | |||
my_backup_pi_scripts.1470334457.txt.gz · Last modified: 2023/03/09 22:35 (external edit)