Solved

'max_allowed_packet' Error With Reload of Database Dump

Posted on 2006-11-26
3
584 Views
Last Modified: 2012-06-21
"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!
0
Comment
Question by:runningone
3 Comments
 
LVL 30

Accepted Solution

by:
todd_farmer earned 500 total points
ID: 18014444
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now