170
edits
Changes
Jump to navigation
Jump to search
no edit summary
Wishlist:
*[[Server Backup Policy: under development]]
*[[McNair Security Policy]]
*[[Power Backup]]
# PowerShell should say "PS E:\Processing\SDC Data>" or a different filepath if you moved the script.
# Now in order to use the script type "perl NormalizeFixedWidth.pl -file='name of file to normalize (make sure to include the single quotes on the outside and the file extension or the script won't work)' "
== Server Backup ==
Current backup policy is to backup all MySQL databases from the server 128.42.44.180. This is done using the script
/root/scripts/web_mysqldump_backup.plx
The script uses mysqldump and rsync for backup. The backups are stored on an external usb HDD. 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
/media/usb_backup/mysqldump/
It also updates a backup log
/var/log/web_mysqldump_backup.log.gz
[[category:McNair Admin]]
[[category:Internal]]
