[rt-users] Restoring Mysql - Max_allowed_packet-

[Schultz, Eric]

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 at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Sebastian
Suarez
	Sent: Thursday, May 04, 2006 10:46 AM
	To: rt-users at 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.