on the server
We have a crontab running every 6 hours that runs a database backup:
# crontab -l | grep db_backup 10 */6 * * * /root/db_backup.sh >/dev/null 2>&1
$ cat /root/db_backup.sh
#!/usr/bin/bash -x
backupdir='/root/databases'
datestamp="$(date +%Hh%d-%m-%Y)"
if [[ ${EUID} -ne 0 ]]; then
echo "This program expects to be run as root." 1>&2
exit 127
fi
mysqldump --add-drop-database --log-error=${backupdir}/pw-server_all_${datestamp}.sql.log --verbose --result-file=${backupdir}/pw-server_all_${datestamp}.sql --all-databases
find ${backupdir} -mtime +1 -print -delete 2>&1 | tee ${backupdir}/pw-server_all_${datestamp}.cleanup.log
local backup script
TODO
- some kind of archival and/or versioning of the webroot? (right now I get it from the backup host filesystem)
If you run this yourself you'll need to change the "shebang" line referencing bash, and the backupdir.
$ cat bin/wikibackup_pull.sh
#!/opt/homebrew/bin/bash -x
backupdir='/Volumes/home/Misc_Backups/prolewiki'
datestamp="$(date +%Hh%d-%m-%Y)"
if [[ ! -d ${backupdir} ]]; then
echo "Cannot access backup directory \`${backupdir}\`, exiting" 1>&2
exit 2
fi
mkdir -pv ${backupdir}/{database,public_html}/
time rsync -ave 'ssh -p 22022' --delete root@www.prolewiki.org:/home/prole/public_html/ ${backupdir}/public_html/ 2>&1 | tee ${backupdir}/public_html_rsync.log
time rsync -ave 'ssh -p 22022' --delete root@www.prolewiki.org:/root/databases/ ${backupdir}/database/ 2>&1 | tee ${backupdir}/databases_rsync.log
zip -Tr ${backupdir}/${datestamp}.zip ${backupdir}/database ${backupdir}/public_html