crontab mysqldump err mail

[BubikolRamios]

if I run mysqldump from crontab and error occurs, I would like to have email send to me (reporting that backup is not working).

Can this be done ?

[daedae]

Should be doable. Something similar to the following should work ( not tested ):

mysqldump --opt --user=mysqluser --password=secretpass dbname > dbname.sql || echo "mysqldump failure message" | mail -s 'mysqldump error' user@domain.com

Basically, the stuff after the '||' is only executed if the command before it returns a non zero exit code. A successful mysqldump should return 0 and therefore no email would be sent.

Hope this helps.

[BubikolRamios]

Thanks a lot, tested it and it works.

Didn't notice for a month that there are no 'usable' backups on
production server. By pure luck spoted that mysqldump generated files
were way to small.

No such problem in the future.