In my production server i have a very huge database with 127 tables
and lots of table has blob fields
I have an exact replica of the same in my test server , when i take a back up from my prodicution and run the script in my test server i get a error max_allowed_packet error
i've set the max_allowed_packet to 16mb in my.cnf and i don't have any record which has more that 16mb data
if i do a source \path\backupscript.txt in the mysql prompt it doesn't give any error
if i do mysql db < \path\backupscript.txt in the shell it throws the max_allowed_packet error
