Problem with "packet bigger than 'max_allowed_packet' error"

[kendi77]

Hi
I am running an update to a database and I keep getting this error:


Could not Insert to CB_MAIN (update)Got a packet bigger than 'max_allowed_packet' bytes
And it is from this code:

$result_upd = mysql_query($sql_upd) or write_error("Could not Insert to CB_MAIN (update)".mysql_error()." \r\n");
 

The write_error() function writes to a log and on line no. 79,870 I get that error.

Searched and read this:

Quote:
You probably have to change it for both the client (you are running to do the import) AND the daemon mysqld that is running and accepting the import.
But didn't understand it.

My system is as follows:

Operating system CentOS Linux 6.0
Perl version 5.010001
Path to Perl /usr/bin/perl
BIND version 9.7.0
Postfix version 2.6.6
Apache version 2.2.15
PHP version 5.3.2
Webalizer version 2.21-02
Logrotate version 3.7.8
MySQL version 5.1.52

Would much appreciate it if some would help me by telling me what config files need to be changed and where they might be.

Thanks.

[Atli]

Hi.

Read the manual page on this issue. It explains what's going on and what you need to change.

C.5.2.10. Packet too large.