Divide projects into different mantises from one mantis DB

[mmetan]

Hi all.

I'im having a mantis where several projects are defined under the same DB. What i want to do is that divide these projects into separate mantis DBs.

such as I have a mantis named ABC. there are three different projects defined under this mantis where A, B, and C. There are also many subprojects under those projects such as A.1, A.2, A.n, B.1, B.2, B.n etc..

There are almost ten thousand issues for each.

How can i securely divide those into seperate mantisses such as mantis.com/A mantis.com/B mantis.com/C rather than mantis.com/ABC.


any helps are highly appreciated. It's a bit urgent too...Thanx.
best regards.

[mmetan]

using version 1.0.6 by the way...

thanx.

[olegos]

Dump the database, restore into multiple databases, configure each Mantis instance to talk to its own DB, and delete extra projects in each.

[mmetan]

Dump the database, restore into multiple databases, configure each Mantis instance to talk to its own DB, and delete extra projects in each.

You mean clone the DB and delete unwanted projects from each DB? There wont be any side affects? What about table Relationships?

or

do you mean divide the DB into projects? is it that easy mate? there are several releationships upon tables. where mantis_project_table, custom_field_table, custom_field_project_table, project_string_table, etc etc etc...

My appologies... i didn't understand.... can you be more specific?

thanx so much by the way.

[olegos]

I meant your first case, clone the database, and delete what you don't need in each one. Yes, I think you will lose relationships between issues that end up in different databases, but what else would you expect? You can't have a "relationship" with something outside of your own instance. All bug numbers and note numbers will be preserved.