shellscripts:mysql_dump

MySQL-Backup

Exportiert die angegebenen Datenbanken und verschickt diese an die angegebene Adresse.

#!/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