'max_allowed_packet' Error With Reload of Database Dump

"ERROR 1153 (08S01) at line 33291: Got a packet bigger than 'max_allowed_packet' bytes"

We're getting the error above when trying to restore a dump to a new database.

We have continuosly adjusted up with the following command but keep getting the error.

mysql> set max_allowed_packet = 300000000;

Is there somewhere else that we need to adjust?

I've read some about my.cnf, but am not sure if I need to change it, or what to change in it. Also, there are multiple versions of my.cnf?

Background: new to Linux!
runningoneAsked:
Who is Participating?
 
todd_farmerConnect With a Mentor Commented:
There is both a session variable and global variable for this.  Try setting the global variable:

set @@global.max_allowed_packet = 300000000;

Also, you can set this parameter in the defaults file (/etc/my.cnf):

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
http://dev.mysql.com/doc/refman/5.0/en/option-files.html

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.