Enhance Export Script with Assertion/Comment on @@global.max_allowed_packet size
Okay, I ran in to a problem when I backed up MySQL on one server and tried to restore to another machine. The target machine did not have a LARGE Enough value for @@global.maxallwoedpacket size.
This caused HUGE Blob fields to NOT load (and in fact, stopped the script from continuing SILENTLY).
By adding an ASSERTION or maybe forcibly setting the value for the script, it would have processed correctly.
To me, this is a variation of setting the DATE format at the top of the script.
At the very least, a comment in the script would have been nice as a HINT to confirm this if there are problems loading!