Websites | Photography | Video Editing | 3D Animations

From the Blog

Apr
03

MySQL: How to fix ERROR 1153 (08S01) in Centos 5

Posted by Paul Costan on April 3rd, 2012 at 2:49 pm

To increase ‘max_allowed_packet’.

I came across this issue when trying to import 1.6gb sql dump. It took me a couple of hours to figure this out. So here is how I did it…

Go and edit this file:
# nano /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
max_allowed_packet=64M <----- Add this line to 16m, 64m, 128, or 256m socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

After you will need to do mysql restart, then check status by typing in the following command

# mysql service status

You should see below of succesful:

max_allowed_packet | 67108864

  • prakash

    The post helped me. It Works thanks a lot..