[rt-users] RE: RT2 Database Restore Fails

[Phil Homewood]

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 at snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances