Posted By

daipratt on 02/02/11


Tagged

mysql


Versions (?)

Increase the max_allowed_packet in MySQL


 / Published in: MySQL
 

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

If you every get hit by ERROR 1153 (08S01): Got a packet bigger than 'maxallowedpacket' 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.

  1. #To access mysql console
  2. mysql -u username -p -h localhost
  3.  
  4. #See variable max_allowed_packet and then set it to 100Mb
  5. SHOW variables LIKE '%max_allowed_packet%';
  6. SET global max_allowed_packet=1000000000;
  7.  
  8. #exit
  9. /x
  10.  
  11. #run import
  12. mysql -u username -p -h localhost database_name < sql_to_import.sql

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: daipratt on February 2, 2011

This is better than updating the /etc/my.cnf file with global settings

You need to login to post a comment.