'max_allowed_packet' Error With Reload of Database Dump
Posted on 2006-11-26
"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!