Impex Attachment Import

[sdotson]

I got WAMPS up and running on my local so I could more easily import by PHPBB board.

(By the way Jerry I apprecite all your help to date on this. I figured it would be easiest if I could import myself)

Anyway, I'm to the point where I need to import my attachments. I have downloaded them all off my site and placed them in a folder:

C:\wamp\www\forums\attachments

the forums exist at

C:\wamp\www\forums\

So for the full path to the attachments folder I enter:

/www/forums/attachments

or

/forums/attachments

Does not like either one. Tells me it cannot find the files. Am I missing something?

[Jerry]

If its this :

C:\wamp\www\forums\attachments

Then enter that as its the full path and PHP should resolve it.

[sdotson]

Worked like a charm, thanks Jerry

[sdotson]

Actually not quite...

I get this error on one of the files.


ImpEx Database errormysql error: Invalid SQL:
UPDATE vb_attachment
SET
filedata = 'PK\0\0\0\0˜’.ÎýW¹zX2\0hß3\02\0\0\01GHybernat e-Q330909-xp/Q330909_WXP_SP2_x86_ENU.exeì½
XT×µ0|†à\0ƒgT0Ä`œD’š�X’ÑD2š‚p

(snip a bunch of garbage)

filesize = 3299770
WHERE attachmentid = 44


mysql error: MySQL server has gone away

mysql error number: 2006

Date: Wednesday 30th 2006f August 2006 08:28:30 AM
Database: test
MySQL error:

Any way of telling what file it bombed on or how to get past this error?

[Jerry]

It's your database that has bombed, not ImpEx.


mysql error: MySQL server has gone away

Check to see what your max_packet size is for MySQL, if its very small or your database is unreliable, I suggest storing the attachments in the file system.

[sdotson]

The DB seems pretty reliable.

Where is the max_packet setting contained?

[Jerry]

AdminCP > Maintenance > System Information > MySQL Variables

In there will be max_allowed_packet.

What is it's value ?

[sdotson]

1048576

Some of the attachments MIGHT be larger than this. How would I change the mysql settings?

[Jerry]

Would have to talk to your host about that and get their admin to sort it out.

I would suggest using the file system for storage and giving the import another go.

[sdotson]

Actually this import is being done on my locl WAMPS setup so I would change it.

What are the pros/cons to file system storage?