Clean-up database after switch to ArticleStorageFS

Anyone know what is safe to clean (read delete) out of the database after switching OTRS (3.0.11) over to ArticleStorageFS? or if there is something you can run to magically get rid of the redundant articles eating up space in the database? Thanks Steve

My bad, it looks like the otrs.ArticleStorageSwitch.pl did move the
articles out of the 'article_plain' table, but the actual 'article' table
still contains a plaintext copy of the message eating up a fair chunk of
database space.
Steve
On 5 March 2012 13:58, Steven Carr
Anyone know what is safe to clean (read delete) out of the database after switching OTRS (3.0.11) over to ArticleStorageFS? or if there is something you can run to magically get rid of the redundant articles eating up space in the database?
Thanks
Steve

The article table itself should still be in use, for articles. I think
what you moved out of the DB were article attachments, correct?
Hugh
On Mon, Mar 5, 2012 at 9:37 AM, Steven Carr
My bad, it looks like the otrs.ArticleStorageSwitch.pl did move the articles out of the 'article_plain' table, but the actual 'article' table still contains a plaintext copy of the message eating up a fair chunk of database space.
Steve
On 5 March 2012 13:58, Steven Carr
wrote: Anyone know what is safe to clean (read delete) out of the database after switching OTRS (3.0.11) over to ArticleStorageFS? or if there is something you can run to magically get rid of the redundant articles eating up space in the database?
Thanks
Steve
--------------------------------------------------------------------- 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

Yeah it seems to have just moved the article attachments out, I was hoping
to claim back more space than it did, but never mind.
Steve
On 6 March 2012 13:50, Hugh Kelley
The article table itself should still be in use, for articles. I think what you moved out of the DB were article attachments, correct?
Hugh
On Mon, Mar 5, 2012 at 9:37 AM, Steven Carr
wrote: My bad, it looks like the otrs.ArticleStorageSwitch.pl did move the articles out of the 'article_plain' table, but the actual 'article' table still contains a plaintext copy of the message eating up a fair chunk of database space.
Steve
On 5 March 2012 13:58, Steven Carr
wrote: Anyone know what is safe to clean (read delete) out of the database after switching OTRS (3.0.11) over to ArticleStorageFS? or if there is something you can run to magically get rid of the redundant articles eating up space in the database?
Thanks
Steve
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
participants (2)
-
Hugh Kelley
-
Steven Carr