SEO

#1 (**permalink**) 02-28-2008, 09:49 AM

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

#2 (**permalink**) 02-28-2008, 09:49 AM

On 13 May 2007 14:23:06 -0700, "laredotornado@zipmail.com"
<laredotornado@zipmail.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.

#3 (**permalink**) 02-28-2008, 09:49 AM

On May 14, 2:32 am, subtenante <zzsubtenant...@gmail.com> wrote:
> On 13 May 2007 14:23:06 -0700, "laredotorn...@zipmail.com"
>
> <laredotorn...@zipmail.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.

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

#4 (**permalink**) 02-28-2008, 09:49 AM

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

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

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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