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.