Linux Cron Backup Files and SQL
Small note on commands I used for a simple web-account cron backup script.
Bash script for e.g. cron.weekly:
#!/bin/sh # Backup of web files. tar zcfp /var/www/userdomain.me/weekly-backup/FILES.tar.gz -C / var/www/userdomain.me/web # Backup of database. mysqldump --user=username --password=password DatabaseName | gzip > /var/www/userdomain.me/weekly-backup/DATABASE.sql.gz