recentpopularlog in

therobyouknow : size   38

how to change Mysql packet size? - Server Fault
On linux, well CentOS at least, you would edit /etc/my.cnf and add the same text as randy melder says.

You would then need to restart the MySQL server (mysqld) as otherwise it won't know about your change since it only reads it when it starts up.

To restart mysqld: /etc/init.d/mysqld restart

Why would you want to increase your packet size? If you want to import a large file: mysql -u username -p -h localhost databasename < data.sql

With that default setting you might not be able to do the import and you would therefore be presented with the error message: "ERROR 1153 (08S01) at line 53: Got a packet bigger than 'max_allowed_packet' bytes".

So setting max_allowed_packet as described in the answer above can cure that problem, provided your setting is larger than the file you want to import.
mysql  packet  size  change  import  mysqldump  enable  large  error  solution  my.cnf  mysqld  restart  re-read  howto  max_allowed_packet  computing  setting  configuration  dos  denial  service  file  sql  plaintext  export 
july 2010 by therobyouknow

Copy this bookmark:





to read