Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

'max_allowed_packet' Error With Reload of Database Dump

Posted on 2006-11-26
3
590 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
category table 2 30
Complex SQL statement in VB.NET 7 31
java mysql insert application 14 28
reverse engineer .sql from php files 11 34
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 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