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