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 future. 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. On Sun, Dec 2, 2012 at 1:44 PM, Tim Fischer wrote:

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 into the attachment-table?

All other tables seems to be ok. So would it be enought to extract them out of the article_plain table and store them in the article_attachment-table? There are only 12 rows - looks very clearly.

If there is no tool-script i would write my own in perl.

thx

Tim --------------------------------------------------------------------- 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