A Simple Backup Script

Here is a very simple script that saves back up copies of a MySQL database and an Open LDAP user database:

#! /bin/bash

dir=/var/backups/escenic

# db backup
mysqldump ecedb | gzip -9 > $dir/$(date --iso)-ecedb.sql.gz

# ldap backup
slapcat > $dir/$(date --iso)-ece.ldif 2>/dev/null

If you save it in /etc/cron.daily/ece, then it will be run every day, creating daily backups of your databases.