Hello - I just have a quick question about migrating attachments from 1.6 to 1.9. I'd like to keep our attachments out of the database an in their own file system. I was able to get this function working in 1.9, but is there any way to migrate our 1.6 attachments directly into 1.9 using the file system? As I understand it, the only way to do that would be to migrate the attachments into the database, and then (using the plugin) migrate them back out into a file system. Any help is appreciated!On a side note - is it better to store attachments in the database when there are a lot of them (over 10 gigs) - I've read it's probably better not to do this, but I'm not sure.Thank you!

Sadly, I don't think so.I'll ping the devs and ask them, but I think that you have to upgrade (and migrate them in) and then use the migrate commands to move them back out.

Is it better to keep attachments in the database? Really not knowledgeable about attachment storage.  We have +20gb in attachments in 1.6 being upgraded to 1.9That's for checking with the Devs!

Better?I suppose that's a matter of opinion.  Here is a quick off the top of my head list of reason that one might prefer one storage option over the other:files stored in the file system generally take up more space due to block size of the file system. files stored in the file system mean If you want to move your installation from server A to server B you have to move a lot more files.file system storage has no de-duplication of identical files. files stored in a database are not subject to filesystem permission issues.files stored in a database mean another DB query (which could eventually cause performance degradation).Some web hosts limit MySQL database size so moving files to filesystem can get you around this limitation some what.

I'm sure that there are other pros/cons to both that I'm not thinking about.  But I figured that I would at least give you something to think about. :)

Write a Reply...