Restoring Mysql - Max_allowed_packet-

Hi guys,

Im trying to restore my RT database (.sql dump backup) into my new box
(running FC4 - RT3.5.5)

The following error appears:

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

Doing some google I found and try this
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html but without
look.

Any clue?

Thanks

Seb.-

You can:

  • restart the mysql daemon with the size of max_allowed_packet increased
    (as specified in my.cnf):

[mysqld]
max_allowed_packet=16M

  • with an already running daemon, (at least, on 4.x), enter at the mysql
    prompt:

mysql> set global max_allowed_packet=16777216;

(this sets it to 16MB).

If you did your dump with extended inserts, you will have to make this
much bigger.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Sebastian
Suarez
Sent: Thursday, May 04, 2006 10:46 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Restoring Mysql - Max_allowed_packet-

Hi guys,

Im trying to restore my RT database (.sql dump backup) into my

new box (running FC4 - RT3.5.5)

The following error appears:

ERROR 1153 (08S01) at line 129: Got a packet bigger than

‘max_allowed_packet’ bytes

Doing some google I found and try this

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html but without
look.