mantis_bug_file_table too large and where are the files?

Get help from other users here.

Moderators: Developer, Contributor

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

mantis_bug_file_table too large and where are the files?

Post 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
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: mantis_bug_file_table too large and where are the files?

Post 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?
Please use Search before posting and read the Manual
Post Reply