Home > MySQL > Mysql ERROR 1153 (08S01) Got a packet bigger than ‘max_allowed_packet’ bytes

Mysql ERROR 1153 (08S01) Got a packet bigger than ‘max_allowed_packet’ bytes

That error while recovering the database file from already backup file.

1.

mysql> show variables;

| max_allowed_packet              | 1048576                                                    |

2. vi /etc/my.cnf

[mysqld]
max_allowed_packet=16M

3. service mysqld restart

4. mysql –user=root –password= < /tmp/myfailedfile.sql

Done.

Advertisements
Categories: MySQL
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: