Dump database file

.my.cnf

[mysqldump]
user=root
password=INSERT_PASSPHRASE_HERE

crontab

# Take a backup of the database with dumpie every day at midnight (0:00)
0 0 * * * /home/nico/utils/dumpie > /home/nico/dumpie.log
# Take a backup with Aegis every Sunday at 1:00
0 1 * * 0 /home/nico/aegis/aegis backup:dropbox /home/nico/aegis/jobs/backup.yaml > /home/nico/aegis.log

dumpie

#!/bin/sh
rm /var/www/nicoverbruggen.be/storage/dump.sql;
echo "Dumping database of nicoverbruggen.be...";
mysqldump nicoverbruggen > /var/www/nicoverbruggen.be/storage/dump.sql;
echo "Done.";