8 gig article_attachments table on windows xp

[deansyst]

we have an otrs server that that runs on a windows xp box . the DB is almost 24.7 gigs inisize .with the article_attachments table being 8 gigs in size , this is because all the attachments and emails
are kept in the database.
I need to trim the database to a manageable size for back up purposes and was wondering if any of you guys out there have had any experience
/ pointers on how to trim down the data base.

there are future plans to migrate the OTRS server on a Linux platform.but the data base size is an issue.are there any documents or scripts that
i can use to delete old attachments.


ORTS Ver 3.1.4
OS ver Windows xp
DB ver Mysql 5.1

[reneeb]

You could save the attachments on file system... see viewtopic.php?f=53&t=16418

[deansyst]

before changing the mail storage from the DB to the FS . i still need to do some house
cleeaning on the current Humongous BD that is 24 gigs in size

[arvas]

do note when you change the db type the attachments in the old db will no longer be accessible until you reactivate the old db... it sucks finding this out midway

[jojo]

you can move the attachments via script from one storage into another (please read the description in Sysconfig)

[arvas]

wow jojo i did not know that.... im doing it now, if this works it'll be so awesome! getting a bunch of errors but it keeps moving onto the next, thats probably cos of the switch and use so i think thats normal..