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)
			
			
									
						
										
						Removing old attachments from database
Moderators: Developer, Contributor
Re: Removing old attachments from database
Guess I'll take the lack of responses as a "NO"
			
			
									
						
										
						Re: Removing old attachments from database
Shuold help, check table mantis_bug_file_table
https://mantisbt.org/docs/erd/mantisbt_ ... erd_r1.pdf
			
			
									
						
										
						https://mantisbt.org/docs/erd/mantisbt_ ... erd_r1.pdf
Re: Removing old attachments from database
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).
			
			
									
						
										
						I found that to be the best solution (a specific directory per project).
Re: Removing old attachments from database
I tried that but was unable to make it work (Linux)
			
			
									
						
										
						Re: Removing old attachments from database
if you get a time-out, look here:
viewtopic.php?f=3&t=25553&p=65376&hilit ... nts#p65376
			
			
									
						
										
						viewtopic.php?f=3&t=25553&p=65376&hilit ... nts#p65376