170
edits
Changes
Jump to navigation
Jump to search
→Server Backup
== Server Backup ==
Backups are written to an external usb HDD at midnight everyday by invoking backup scripts from cron. Backup logs are also updated.
=== web server ===
Current backup policy is to backup all MySQL databases from on the server 128.42.44.180. Backups are written to an external usb HDD at midnight everyday by invoking following script from cron. A backup log is also updated.
Backup script: /root/scripts/web_mysqldump_backup.plx
Backup destination path: /media/usb_backup/mysqldump/
The script uses mysqldump and rsync for backup. As of 6-13-2016, backup destination paths are hard-coded in the script.
#TO DO: add command line options like --backup-destination= remote/local, --verbose/quiet
redo this script like for database server (see below) because its cleaner..
To see more information see perldoc
=== database server ===
Backup script: /root/scripts/db_pgdump_backup.plx
Backup destination path: /media/usb_backup/pgdump/
Backup log: /var/log/db_pgdump_backup.log
The script uses pg_dump for backup. All databases are then collected in a tar archive.
As of 6-15-2016, backup destination paths are hard-coded in the script.
#TO DO: add command line options like --backup-destination= remote/local, --verbose/quiet
To see more information see perldoc
perldoc /root/scripts/db_pgdump_backup.plx
=== RDP server ===
