Move articles from database to filesystem
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? 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". I'm running OTRS 2.0.4 with Apache 2.0.45 Mysql 4.0.24 on Debian. thanks in advance, Marc -- innovatis AG Marc Redeker Service & Support Im Technologiezentrum Meisenstr. 96 D-33607 Bielefeld / Germany Phone +49 521 2997 278 Mobil +49 160 90888614 Fax +49 521 2997 291 mailto:marc.redeker@innovatis.com http://www.innovatis.com
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.
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.
I'm running OTRS 2.0.4 with Apache 2.0.45 Mysql 4.0.24 on Debian.
thanks in advance,
Marc
Bye, Alex
Hi Alex, otrs-bounces@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.
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
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/
Alexander Scholler
Hi Alex,
otrs-bounces@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
participants (2)
-
Alexander Scholler -
Marc Redeker