Sysadmin Script to get backup notifications on email

Hello

At the moment i am using this bash code (notify.sh) to get an email notification for backup status:

Code:

if /usr/bin/mysqldump bla bla bla /database.sql
then
   echo "${0##*/} mydb database backup worked" | mail -s "WORKED domain.com database backup" email@mymail.com
else
   echo "${0##*/} mydb database backup failed" | mail -s "FAILED domain.com database backup" email@mymail.com
fi

It works but i know that is not the best possible way to do it

So i want to ask if anyone has any other ways to do that or any optimizations for the above code

Also it will be great if it is possible to get the exact output error if the backup command fails on my email.....

Thank you

 

Ok got it but there is no info there on how to get the backup command exact output error and mail it to my email.....

I am using a cron for this script....