Removing old attachments from database

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
KenHorse
Posts: 27
Joined: 22 Dec 2011, 00:07

Removing old attachments from database

Post 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)
KenHorse
Posts: 27
Joined: 22 Dec 2011, 00:07

Re: Removing old attachments from database

Post by KenHorse »

Guess I'll take the lack of responses as a "NO"
atrol
Site Admin
Posts: 8539
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Removing old attachments from database

Post by atrol »

Shuold help, check table mantis_bug_file_table
https://mantisbt.org/docs/erd/mantisbt_ ... erd_r1.pdf
Please use Search before posting and read the Manual
cas
Posts: 1768
Joined: 11 Mar 2006, 16:08
Contact:

Re: Removing old attachments from database

Post 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).
KenHorse
Posts: 27
Joined: 22 Dec 2011, 00:07

Re: Removing old attachments from database

Post by KenHorse »

I tried that but was unable to make it work (Linux)
cas
Posts: 1768
Joined: 11 Mar 2006, 16:08
Contact:

Re: Removing old attachments from database

Post by cas »

Post Reply