Remove article attachment from MySQL Database to File System

Hello, Installing my OTRS last year, I did not realize that Ticket::StorageModule was defaulted to ArticleStorageDB, meaning that all the attachments from a ticket were stored inside of mysql. Three months later I changed it to FS. Now my attachment are store on the file system. But I'd like to remove all the ticket from mysql and store them on the FS. I was wondering if there is a script to do that? Has anybody done this before? Your help will be highly appreciated. Thanks a lot, Touraman

touraman traore schrieb:
Hello, Installing my OTRS last year, I did not realize that Ticket::StorageModule was defaulted to ArticleStorageDB, meaning that all the attachments from a ticket were stored inside of mysql. Three months later I changed it to FS. Now my attachment are store on the file system. But I'd like to remove all the ticket from mysql and store them on the FS. I was wondering if there is a script to do that? Has anybody done this before? Your help will be highly appreciated http://www.otrs-forum.de/viewtopic.php?f=18&p=7353#p7353
.
Thanks a lot,
Touraman ------------------------------------------------------------------------
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

Is there an English version of this article or can I find it on a howto in
English? it's really interesting.
Thanks a lot
On Nov 29, 2007 4:24 PM, monotek@gmx.net
touraman traore schrieb:
Hello, Installing my OTRS last year, I did not realize that Ticket::StorageModule was defaulted to ArticleStorageDB, meaning that all the attachments from a ticket were stored inside of mysql. Three months later I changed it to FS. Now my attachment are store on the file system. But I'd like to remove all the ticket from mysql and store them on the FS. I was wondering if there is a script to do that? Has anybody done this before? Your help will be highly appreciated http://www.otrs-forum.de/viewtopic.php?f=18&p=7353#p7353
.
Thanks a lot,
Touraman ------------------------------------------------------------------------
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/

You can try Google translator. It's not perfect but I think you can get the
gist.
The German to English translation for this is ...(this is a single URL)
http://translate.google.com/translate?u=http%3A%2F%2Fwww.otrs-forum.de%2Fvie
wtopic.php%3Ff%3D18%26p%3D7353%23p7353
<http://translate.google.com/translate?u=http%3A%2F%2Fwww.otrs-forum.de%2Fvi
ewtopic.php%3Ff%3D18%26p%3D7353%23p7353&langpair=de%7Cen&hl=en&ie=UTF-8>
&langpair=de%7Cen&hl=en&ie=UTF-8
_____
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
touraman traore
Sent: Thursday, November 29, 2007 5:43 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] Remove article attachment from MySQL Database to
FileSystem
Is there an English version of this article or can I find it on a howto in
English? it's really interesting.
Thanks a lot
On Nov 29, 2007 4:24 PM, monotek@gmx.net mailto:monotek@gmx.net
Hello, Installing my OTRS last year, I did not realize that Ticket::StorageModule was defaulted to ArticleStorageDB, meaning that all the attachments from a ticket were stored inside of mysql. Three months later I changed it to FS. Now my attachment are store on the file system. But I'd like to remove all the ticket from mysql and store them on the FS. I was wondering if there is a script to do that? Has anybody done this before? Your help will be highly appreciated
http://www.otrs-forum.de/viewtopic.php?f=18 http://www.otrs-forum.de/viewtopic.php?f=18&p=7353#p7353 &p=7353#p7353

The translation is great. I'll give this a try.
On Nov 29, 2007 7:08 PM, LQ Marshall
You can try Google translator. It's not perfect but I think you can get the gist.
The German to English translation for this is ...(this is a single URL)
http://translate.google.com/translate?u=http%3A%2F%2Fwww.otrs-forum.de%2Fvie...
****
------------------------------ *From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *touraman traore *Sent:* Thursday, November 29, 2007 5:43 PM *To:* User questions and discussions about OTRS.org *Subject:* Re: [otrs] Remove article attachment from MySQL Database to FileSystem
Is there an English version of this article or can I find it on a howto in English? it's really interesting. Thanks a lot
On Nov 29, 2007 4:24 PM, monotek@gmx.net
wrote: touraman traore schrieb:
Hello, Installing my OTRS last year, I did not realize that Ticket::StorageModule was defaulted to ArticleStorageDB, meaning that all the attachments from a ticket were stored inside of mysql. Three months later I changed it to FS. Now my attachment are store on the file system. But I'd like to remove all the ticket from mysql and store them on the FS. I was wondering if there is a script to do that? Has anybody done this
before? Your help will be highly appreciated http://www.otrs-forum.de/viewtopic.php?f=18&p=7353#p7353
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/
participants (3)
-
LQ Marshall
-
monotek@gmx.net
-
touraman traore