A Simple Backup Script
Here is a very simple script that saves back up copies of a MySQL database:
#! /bin/bash dir=/var/backups/escenic # db backup mysqldump ecedb | gzip -9 > $dir/$(date --iso)-ecedb.sql.gz
If you save it in /etc/cron.daily/ece
, then it will
be run every day, creating daily backups of your databases.