Antwort: Re: [otrs] Move articles from database to filesystem

[Alexander Scholler]

Alexander Scholler <alexander.scholler at augsburg.de>
Informationstechnik / AfOuI
VZA / Zimmer 631, Durchwahl -4451



Marc Redeker schrieb:
> 
> 
> 
> Hi Alex,
> 
> otrs-bounces at otrs.org schrieb am 03.01.2007 06:45:41:
> 
>> Hi Marc,
>>
>> Marc Redeker schrieb:
>> >
>> > Hello and a happy new year together,
>> >
>> >
>> > i changed the article storage from an MySQL database to Filesystem
>> > (ext3). So from now all articles and attachements are stored on the
>> > filesystem.
>> > Now to my question:  Is is possible to move all existing articles from
>> > the mysql DB to the Filesystem?
>>
>> I heard that it can be changed in any-directions on-the-fly.
> 
> Yes, but when i change it in the config file it only save new articles
> on the fs, the old articles
> are still in the database.

I don't know any script that moves the attachements from DB to FS.
So you have to build it yourself.

> 
>>
>> >
>> > The reason is that customers often send us eMails with 150 uo to 400
>> > jpeg images as simple attachements without using e.g. Zip.
>> > So we have to select every image in the ticket using "save target as".
>>
>> What do you think should change with using FS-storage. You still have to
>> download the attachment via web-gui, regardless of the
> background-storage.
> 
> But then i am able to make the files accessible via ftp or smb,
> read-only naturally.
> 
>>
>> >
>> > I'm running OTRS 2.0.4 with Apache 2.0.45 Mysql 4.0.24 on Debian.
>> >
>> > thanks in advance,
>> >
>> > Marc
>>
>> Bye, Alex
> 
> Marc

Bye, Alex