Server Move and Attachment Table?
 

I'm moving from one server to another. Both using MySQL. Every table copied over just fine* with the exception of the attachment table.

I tried using Navicat's Data Transfer feature* and got this error:

[Msg] [Dtf] Data transfer start
[Msg] [Dtf] Get Table Data from: attachment
[Msg] [Dtf] Drop Table: attachment
[Msg] [Dtf] Create Table: attachment
[Msg] [Dtf] Transfer Data to Server: attachment
[Err] [Dtf] Transfer Data [insert into `attachment` values('30'*'1141'*'1214357692'*'1214357692'*'AMSR S D2 10.55am SMacLean paper v2.doc'*0xd0cf11e0a1b11ae1000000000000000000000000 000000003e000300feff09000600000000000000000000000a 000000e40400000000000000100000e604000001000000feff ffff00000000da040000db040000dc040000dd040000de0400 00df040000e0040000e1040000e2040000e3040000ffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffff fffffffffffffffffffff ... ]: Got a packet bigger than 'max_allowed_packet' bytes

[Err] [Dtf] Terminated

I also tried exporting from phpMyAdmin on one* and importing using the same tool on the other. Exported just fine from the source* but in the target database it just seems to try forever* but doesn't get anywhere. The attachment table is only 2.7 MB in size* so it shouldn't take too long* I wouldn't think.

MySQL Versions...

Source: 5.0.51a
Target: 5.0.81-community

Any ideas?

Thanks.