Find the answer to your Linux question:
Results 1 to 2 of 2
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie
    Join Date
    Dec 2004
    Posts
    105

    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
    Just Joined!
    Join Date
    Dec 2004
    Posts
    12
    Hi

    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 www.mysql.com or if you get stuck give me a shout and I'll try to dig out my notes.

    Cheers

    Spook

Posting Permissions

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