Recently I have setup a cronjob to automatically restore a mysql database. So I created a script like the following

mysql -u<username> -p<password> -h<hostname> <dbname>
< <path_of_exported_database.sql

This script was scheduled through cron service to run every some hours, but I didn’t know if it run with success or no.
I placed this row in the crontab declaration


in order to be notified in case of cron job execution failure. But it was important also to know if the job run or not and with what result.

So I placed the following code under the script for the database restore

if [[ $? -eq 0 ]] ;then
echo "MySQL Restore was successful."
echo "Problems with MySQL Restore."

and now a notification is being sent in every execution of this cron job

By admin