Restore of database using Mysql DUmp
You can check if the return value for the command, if 0 then OK else failure.

Put may put it in shell script as follows:

 mysql &lt; dump.sql 1&gt;err 2&gt;&amp;1 
 if [ $? -ne 0 ]; then 
    echo "dump load failed.";
 fi;


or manually run echo $? and determine the result.