#To access mysql console
mysql -u username -p -h localhost

#See variable max_allowed_packet and then set it to 100Mb
show variables like '%max_allowed_packet%';
set global max_allowed_packet=1000000000;

#exit
/x

#run import
mysql -u username -p -h localhost database_name < sql_to_import.sql

http://zoocha.com/what-we-do/drupal/

If you every get hit by ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes, then this might help.
You also need to make sure that the user that you log in with has SUPER privileges on their account.

Increase the max_allowed_packet in MySQL

mysql

MySQL