Restore of database using Mysql DUmp How would i verify that whatever the backup i have taken is correctly restored or not.

EG:

I am taking backup on live system where inserts are going on.backup size is around 50 GB.I have started the restore of the backup but for some reason i have not enable the log and also my session end.So how i will verify that restore was done successfully.

Before taking the backup i have even not calculated the data_lenght,index_lenght and tables row.So is there any way so that i can confirm that restore is successful

regards
Suraj
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.