Code :

## INFOS MYSQL ## LOGIN=root # Login for mysql PASS=toto # Pass for mysql ## Email ## ADMINMAIL=user@fqdn.com # This is the mail were the saves will be send ## Vars ## TMPDIR=/tmp/baksql # Temp directory ## DO NOT MODIFY NOW ## mkdir $TMPDIR # Backuping databases for databases in "cacti" "information_schema" "mysql" "snort" "wikidb" ; do mysqldump -u$LOGIN -p$PASS $databases > $TMPDIR/$databases-'date +%y%m%d'.sql && baksql=$baksql'echo "Sauvegarde de la base $databases - OK ; "' || baksql=$baksql'echo "Sauvegarde de la base $databases - FAILED ; "' done # Compressing and emailing tar -czf $TMPDIR/mysql_backup.tgz $TMPDIR/*.sql && echo "'echo $baksql'" | mutt -x -a $TMPDIR/mysql_backup.tgz -s "MySQL backup - 'date +%d\-%m\-%Y' - fire" $ADMINMAIL rm -Rf $TMPDIR