after a little scare yesterday, I thought it was finally time for some automatic backups.

here’s a short backup script I run every day to send a backup to gmail:

DATE=`date +"%Y%m%d%H%M%S"`
mysqldump --opt --host=localhost --user=psycho --password=XXXXX DBXXX > /home/psycho/$DATE.dump
gzip /home/psycho/$DATE.dump
echo | mutt -s "Backup $DATE" -a /home/psycho/$DATE.dump.gz XXX.XXX@gmail.com
rm $DATE.dump.gz

and here you can witness the evolution of a skript. This is the same skript a few hours later

#!/bin/bash

cd /home/psycho/

DATE=`date +"%Y-%m-%d-%H_%M_%S"`

mysqldump --opt --host=localhost --user=psycho --password=XXXXX DBXXX > /home/psycho/$DATE.dump

tar -chvf $DATE.tar $DATE.dump \
    sieve.rules \
    exim.spychalski.de \
    exim.spychalski.net \
    bin/* \
    `find spychalski_html/blog/` \
    `find spychalski_html/ -maxdepth 1 -name "*.html"`

gzip $DATE.tar

echo | mutt -s "Backup $DATE" -a /home/psycho/$DATE.tar.gz XXX.XXX@gmail.com

rm $DATE.dump
rm $DATE.tar.gz