Advanced Search

Return to Snippet

Revision: 40430
at February 2, 2011 02:13 by daipratt
Initial Code 
#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
Initial URL 
http://zoocha.com/what-we-do/drupal/
Initial Description 
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.
Initial Title 
Increase the max_allowed_packet in MySQL
Initial Tags 
mysql
Initial Language 
MySQL