Professional Web Applications Themes

Strange error: Got a packet bigger than 'max_allowed_packet' bytes - MySQL

Hi, I'm using MySQL 5.0. I'm trying to import a file exported from phpMyAdmin. The error I'm getting is: ERROR 1153 (08S01) at line 418: Got a packet bigger than 'max_allowed_packet' bytes Line 418 is an INSERT statement. It is very long so I won't post it here. My inclination is that the length of the line is causing the error. I'm turning to you experts, however, to see if there's some setting I can adjust somewhere that will allow me to import this file or if I must break up the file. Thanks for any advice, - Dave...

  1. #1

    Default Strange error: Got a packet bigger than 'max_allowed_packet' bytes

    Hi,

    I'm using MySQL 5.0. I'm trying to import a file exported from
    phpMyAdmin. The error I'm getting is:

    ERROR 1153 (08S01) at line 418: Got a packet bigger than
    'max_allowed_packet' bytes

    Line 418 is an INSERT statement. It is very long so I won't post it
    here. My inclination is that the length of the line is causing the
    error. I'm turning to you experts, however, to see if there's some
    setting I can adjust somewhere that will allow me to import this file
    or if I must break up the file.

    Thanks for any advice, - Dave

    laredotornado@zipmail.com Guest

  2. #2

    Default Re: Strange error: Got a packet bigger than 'max_allowed_packet' bytes

    On 13 May 2007 14:23:06 -0700, "com"
    <com> wrote:

    In your MySQL installation folder, you may have a my.ini file.
    Add something like somewhere inside off it :

    max_allowed_packet=16M

    and restart your server.
    subtenante Guest

  3. #3

    Default Re: Strange error: Got a packet bigger than 'max_allowed_packet' bytes

    On May 14, 2:32 am, subtenante <com> wrote: 

    I added this to /etc/my.cnf in two places (see below) but to no
    avail. I still get the error.

    [mysqld]
    datadir=/var/lib/mysql
    socket=/tmp/mysql5.sock
    # Default to using old password format for compatibility with mysql
    3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1

    [mysql.server]
    user=mysql
    basedir=/var/lib
    max_allowed_packet=32M

    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    [client]
    socket=/tmp/mysql5.sock
    max_allowed_packet=32M

    - Dave

    laredotornado@zipmail.com Guest

  4. #4

    Default Re: Strange error: Got a packet bigger than 'max_allowed_packet' bytes

    On 14 May 2007 07:25:58 -0700, "com"
    <com> wrote:

     

    Do you know the size of the file exported by MySQL ? You're sure it is
    under 32MB ?
    You need to restart the server for the changes to take effect, did you
    do it ?

    Apart from these, if the size is less than 32MB, and you restarted,
    and it still doesn't work, I really don't know what to tell you.
    subtenante Guest

Similar Threads

  1. Replies: 0
    Last Post: January 20th, 06:41 PM
  2. max_allowed_packet from MySQL to php-client
    By Ville Ahonen in forum PHP Development
    Replies: 2
    Last Post: August 23rd, 09:11 PM
  3. Strange Error: - Bytes Not Ready
    By Douglas Spooner in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: May 18th, 03:21 PM
  4. strange packet denial
    By dzpost@dedekind.net in forum Debian
    Replies: 1
    Last Post: July 8th, 08:00 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139