Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    mysql problem from ssh.please help

    Trying to install a sql to a newly created db but got the error below:

    root@server [~]# mysql -uuser_vb -p user_dbname </home/user/public_html/user_dbname.sql
    Enter password:
    ERROR 1153 at line 8362: Got a packet bigger than 'max_allowed_packet'

    How can I fix that? The sql is only 29MB in size.

  2. #2

    I've had this on an HPUX box.

    Set max_allowed_packet = 1M in /etc/my.cnf in the [mysqld] section and restart mysqld.

    I did some research when it was a problem for me but I can't remember the details. Try looking up the max_allowed_packet configuration paramter in the online docs on or if you get stuck give me a shout and I'll try to dig out my notes.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts