mantis_bug_file_table too large and where are the files?

Get help from other users here.

Moderators: Contributor, Developer

Post Reply
frankliuao
Posts: 1
Joined: Apr 03, 2018 5:54 pm

mantis_bug_file_table too large and where are the files?

Post by frankliuao » Apr 03, 2018 6:03 pm

Hi there,

I'm trying to transfer the MantisBT to a new host. The large DB size is giving me a hard time.

I checked my DB, the table mantis_bug_file_table is the largest one, roughly 100 MB. From phpMyAdmin I could see the column "content" took a lot of space, but first of all I can't figure out where the file is, and how to export this and re-import.

Anyone having any issue because this table is too large? THanks

atrol
Site Admin
Posts: 7287
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: mantis_bug_file_table too large and where are the files?

Post by atrol » Apr 04, 2018 2:32 pm

frankliuao wrote:
Apr 03, 2018 6:03 pm
I could see the column "content" took a lot of space, but first of all I can't figure out where the file is
There is no file. The "content" column contains the attachment.

Mantis can be configured to store attachments in database (what you have) or to store them on file system.
There are utilities to migrate database attachments to file system attachments.

Which Mantis version do you use?

BTW, 100MB is not that large for attachments and I would not expect serious issues. Is this a typo and you mean 1000MB or even more?
Please use Search before posting and read the Manual

Post Reply