Automated mysql cronjob backups

This will run ever day at 11:00:

0 11 * * * mysqldump -u digitaliq-production digitaliq-production --password=password123 > "/var/www/backups/dbdump_$(date +\%$).sql"

Delete files after 5 days:

find . -type f -mtime +5 -name '*.sql' -execdir rm -- '{}' \;

Tags: