====== MySQL-Backup ======
Exportiert die angegebenen Datenbanken und verschickt diese an die angegebene Adresse.


<code bash>
#!/bin/bash
# Backup+mail your Databases
hostname=`hostname`
dump=Backupdatei.sql
arch=Backupdatei.sql.bz2
email=YOU@YOURDOMAIN.COM

# dump databases, asks for password if not set in .my.cnf
# see http://dev.mysql.com/doc/refman/5.0/en/password-security.html
mysqldump --all-databases -u root > $dump
# only some Databases:
# mysqldump -B yourDB1 yourDB2 yourDB3 -u root > $dump

# compress (bz2)
tar cjf $arch $dump

# mail it
echo "MySQL-Backup von $hostname" | mutt -a $arch -s "MySQL-Backup $hostname" $email

# delete files
rm $dump
rm $arch
</code>