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.