RT2 Database Restore Fails

Hi Guys,

On trying to do a full restore my RT2 database I get the following error:

ERROR 2006 at line 86: MySQL server has gone away
The mysqld shows that it did not crash and my wait timeout is set to 28800.
My RT2 application is located on a UNIX box and is on the same machine as
the mysql db I then tried restoring the database one table at a time. I was
successful in restoring all the tables except the Attachments table which is
approx 800M in size. My db is approx 1.1G in size.
Does anyone have any idea what may be causing this error and how to fix it?

Thank you
Hillary

“The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from all
computers.”

Gororo, Hillary wrote:

ERROR 2006 at line 86: MySQL server has gone away
The mysqld shows that it did not crash and my wait timeout is set to 28800.
My RT2 application is located on a UNIX box and is on the same machine as
the mysql db I then tried restoring the database one table at a time. I was
successful in restoring all the tables except the Attachments table which is
approx 800M in size. My db is approx 1.1G in size.
Does anyone have any idea what may be causing this error and how to fix it?

You may have an old buggy version of mysql, and/or you’re
trying to insert objects into the database that exceed the
server’s max_allowed_packet size.
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances