UnixServerAdmin

Server Administration & Management

MySQL: max_allowed_packet

Some times, when you backup or restore your database table with huge binary data, you will get max_allowed_packet error.

By default MySQL set the max_allowed_packet to 10M.

# mysqladmin variable | grep max_allowed_packet

| max_allowed_packet                      | 10485760

To fix it, change your MySQL global variable as step below.

1. Open /etc/my.cnf file.

# vi /etc/my.cnf

2. Insert the value as below.

=======================
[mysqld]
max_allowed_packet = 64M
=======================

3. Save it and restart the MySQL services.

# /etc/init.d/mysql stop

# /etc/init.d/mysql start

Advertisements

April 2, 2011 - Posted by | MySQL |

2 Comments »

  1. I’ve recently been searching for specifically these details. Despite the fact that I was wanting to come across this article I’m definitely impressed that your blog was so easy to find and just how it completely in comparison to my own , personal experience.

    Comment by filtered water | June 15, 2011 | Reply

  2. I can tell that your knowing of this topic is profound and thorough. What a delicacy to discover somebody writing whom not only offers knowledge but also the opportunity to connect through simple to imagine and remember info-bytes. Write more!

    Comment by filtered water | June 16, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: