#!/bin/sh
# dump database
mysqldump -u cacti --password="cacti" cacti > /home/sysadm/cacti_mysql_dump
# archive files
tar -cvpzf /home/sysadm/my_cacti_backup.tgz /etc/cacti /var/lib/cacti /home/sysadm/cacti_mysql_dump
#rsync it to somewhere safe - NOTE!!! YOU HAVE TO ADJUST THIS LINE!
rsync -avz --verbose  --progress --stats -e "ssh -i /path/to/your_ssh_key" /home/sysadm/my_cacti_backup.tgz user@your.server.org:/path/my_cacti_backup.tgz
#or just scp it to somwhere ... 
#then send a mail
echo "hello you – your cacti backup up has just run" | mail yourself@your.server.org -s cactibakup
exit 0