I made the script
############################################################
#! /bin/sh
export PATH=$PATH:/opt/mysql/bin/
#echo $PATH
echo $LD_LIBRARY_PATH
USER="root"
PASS="qwa"
DB="shell"
DATE=$(date +%d%b%y_%k.%M.%S)
#DATE=`date +%y-%d-%m`
mysqldump -u $USER -p$PASS $DB | gzip -9>/home/backup/today_sme-$DATE.sql.gz
find /home/smebackup -mtime +60 -exec rm -f {} \;
# script to send simple email
# email subject
SUBJECT="live sme database backup"
# Email To ?
EMAIL="xyz
@wqs.com"
# Email text/message
EMAILMESSAGE="/tmp/emailmessage.txt"
echo "Backup of shell database is done successfully"> $EMAILMESSAGE
# echo "This is email text" >>$EMAILMESSAGE
# send an email using /bin/mail
/bin/mail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE
echo "done"
############################################################
It does
1=takes backup
2=delete file before 60 days
3=send a mail
But when I channged mysqldump-->sqldymp (just for test purpose) still it send mail "backup done successfully" while mysqldump command doesnot execute
I want If command execute successfully then only mail should be sent How can I do this