Re: [otrs] Clean-up database after switch to ArticleStorageFS

2012-03-06 Thread 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 sjc...@gmail.com wrote: My bad, it looks like the otrs.ArticleStorageSwitch.pl did move the articles out of

Re: [otrs] Clean-up database after switch to ArticleStorageFS

2012-03-06 Thread Steven Carr
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 hugh.kel...@gmail.com wrote: The article table itself should still be in use, for articles. I think what you moved out

[otrs] Clean-up database after switch to ArticleStorageFS

2012-03-05 Thread 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

Re: [otrs] Clean-up database after switch to ArticleStorageFS

2012-03-05 Thread 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 sjc...@gmail.com wrote: