Page 1 of 1

Removing old attachments from database

Posted: 05 May 2020, 16:19
by KenHorse
My Mantis MySQL database is HUGE, mostly due to old uploads that are no longer needed.

Is there an easier way to delete them other than going through each post and deleting them?

(version 2.4.0)

Re: Removing old attachments from database

Posted: 07 May 2020, 22:52
by KenHorse
Guess I'll take the lack of responses as a "NO"

Re: Removing old attachments from database

Posted: 08 May 2020, 19:17
by atrol
Shuold help, check table mantis_bug_file_table
https://mantisbt.org/docs/erd/mantisbt_ ... erd_r1.pdf

Re: Removing old attachments from database

Posted: 10 May 2020, 11:57
by cas
You also can move the attachements out of the DB onto the file system.
I found that to be the best solution (a specific directory per project).

Re: Removing old attachments from database

Posted: 10 May 2020, 16:36
by KenHorse
I tried that but was unable to make it work (Linux)

Re: Removing old attachments from database

Posted: 10 May 2020, 17:17
by cas