MySQL: A problem when restoring a MySQL database…

If you encounter problems when restoring from a mysql dump, try setting these variables before running the source command

set foreign_key_checks=0;
set global max_allowed_packet=16760832;
set global net_buffer_length=16760832;