Server Move and Attachment Table?

[Scott Spain]

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','AMSRS D2 10.55am SMacLean paper v2.doc',0xd0cf11e0a1b11ae1000000000000000000000000000000003e000300feff09000600000000000000 000000000a000000e40400000000000000100000e604000001000000feffffff00000000da040000db040000dc 040000dd040000de040000df040000e0040000e1040000e2040000e3040000ffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 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.

[Trevor Hannant]

Given you're having problems with it, I'd move the attachments from the database to the file system, then back up your files and database and do your move then...

[veenuisthebest]

What he said ^^

OR

Got a packet bigger than 'max_allowed_packet' bytes

Happening because you are importing via phpmyadmin, which is not a good practise. Most reliable way to backup AND import is via SSH.

[dboogie2288]

I'm not entirely sure where we store our files, but how does one remove it from the DB and move it to the file system? Will there be any noticable change to the users?

[dboogie2288]

I'm not entirely sure where we store our files, but how does one remove it from the DB and move it to the file system? Will there be any noticable change to the users?

bump. a little help?

/edit...disregard, found it easily enough