Page 1 of 1

mantis_bug_file_table too large and where are the files?

Posted: 03 Apr 2018, 23:03
by frankliuao
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

Re: mantis_bug_file_table too large and where are the files?

Posted: 04 Apr 2018, 19:32
by atrol
frankliuao wrote: 03 Apr 2018, 23:03I 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?