Any tool/utility to housekeep data

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
raymondfong
Posts: 2
Joined: 17 Jan 2018, 08:46

Any tool/utility to housekeep data

Post by raymondfong »

As database is getting bigger, is there any tool to discard the old data from the database e.g. using the creation date as criteria? Thanks!
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Any tool/utility to housekeep data

Post by atrol »

raymondfong wrote:As database is getting bigger
What does "big" mean?
Which database table is the biggest one?
Please use Search before posting and read the Manual
raymondfong
Posts: 2
Joined: 17 Jan 2018, 08:46

Re: Any tool/utility to housekeep data

Post by raymondfong »

Q1. as we allow more projects using the same mantis due to limited hardware resources and we want to discard those records which are very old (several years ago) to accommodate new projects.
Q2. we want to trim the whole database but not specific tables.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Any tool/utility to housekeep data

Post by atrol »

raymondfong wrote:we want to discard those records which are very old (several years ago)
Might be no good idea.
Typically some months later you will hear users asking for removed data.

That's why I am asking for the biggest table, e.g. it could be the file attachments table if you store attachments in database.
In this case, it could be better to keep all data, but just move the attachments to file system.
Please use Search before posting and read the Manual
Post Reply