By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,440 Members | 1,041 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,440 IT Pros & Developers. It's quick & easy.

Problem with "packet bigger than 'max_allowed_packet' error"

P: 1
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:
Expand|Select|Wrap|Line Numbers
  1. $result_upd = mysql_query($sql_upd) or write_error("Could not Insert to CB_MAIN (update)".mysql_error()." \r\n");
  2.  
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.
Dec 25 '11 #1
Share this Question
Share on Google+
1 Reply


Atli
Expert 5K+
P: 5,058
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.
Dec 29 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.