Re: [otrs] restore article_attachment from article_plain after table crash

2012-12-03 Thread David Boyes
. Also, I'd consider whether filesystem/FS storage of attachment would be a better choice if they're that important to your workflow, as they'd be out of the database and able to be backed up via filesystem. I would probably concur. Wrt to where attachments are stored, if storing the attachmen

Re: [otrs] restore article_attachment from article_plain after table crash

2012-12-02 Thread Gerald Young
Unfortunately, I don't see how this would be possible or even get what you want. The schema is different between plain and attachment and plain holds the body, while the attachment hold the ... This would be a good case for attempt to export before repair and I recommend automysqlbackup in the futu

[otrs] restore article_attachment from article_plain after table crash

2012-12-02 Thread Tim Fischer
Hi, in my otrs installation i've a partly destroyed article_attachment table. All attachments of 2 month are lost after repair proccess. I saw that the attachments are still saved in the article_plain table. Is there a simple method or tool to "convert" the attachments out of the plain e-mail int