[rt-users] mysql database copy fails with packet bigger than allowed

Les Mikesell les at futuresource.com
Tue Aug 30 12:04:05 EDT 2005


I started with RT-3.0.11 on a fedora FC2 box, upgraded through rt-3.2.2
and added RTFM-2.0.4.  Then I moved this database to a Centos4 box
using mysqldump --opt rt3 >rt.sql on the old server and
mysql rt3 <rt.sql on the new one.  Then I upgraded the new server
to 3.4.2, then 3.4.3 and RTFM 2.1-TESTING.  All of that appeared to go
well and is working although I haven't done much with RTFM yet.

My problem is, I am trying to repeat the process of moving the
database to yet another server and the file I now get from
mysql --opt rt3 on the working server gives an error:
"ERROR 1153 (08S01) at line 76: Got a packet bigger than
'max_allowed_packet' bytes"
when I try to recreate it on the new box with "mysql rt3 <file".
At the moment I'm just trying to make a test version, but now I'm
concerned that I won't be able to restore backups of the main
system unless I resolve this.  I've tried adding:
max_allowed_packet = 1000M
to /etc/my.cnf without any change. Can something be wrong with
the database?

-- 
  Les Mikesell
    les at futuresource.com





More information about the rt-users mailing list