Page 1 of 1

Import and exporting of a mantis instance

Posted: 04 May 2006, 17:44
by strathmeyer
I would like to move two instances of mantis into one instance; I don't suppose anything has happened in the last year that would make this feasable:

http://forums.mantisbt.org/viewtopic.ph ... ght=export

A manager is asking me how much time this would take. I imagine first I'd have to renumber all of the users (since they aren't the same on both systems) and update all the apropriate tables, which in and of itself seems like a huge task. Then I'd have to renumber the id's of everything else... ugh... so is this impossible?

Posted: 18 May 2006, 11:54
by tobala
hi

I also have a problem like this. We have two Mantis servers at two differnet sites and I want to join them to only one database. Is there a way to export the projects from server 1 and import them into server 2?

greetings
tobi

Posted: 18 May 2006, 14:36
by vboctor
At the moment, these scenarios are not supported. And yes, there is a fair bit of work involved.

Regards,
Victor
MantisConnect
http://www.futureware.biz/mantisconnect/

Merging multiple databases

Posted: 25 Jun 2006, 12:31
by cas
I have developed some scripts that take care of this.
So far all seems to be working fine, the following tables are all converted:
mantis_bug_file_table
mantis_bug_history_table
mantis_bug_monitor_table
mantis_bug_relationship_table
mantis_bug_table
mantis_bug_text_table
mantis_bugnote_table
mantis_bugnote_text_table
mantis_custom_field_project_table
mantis_custom_field_string_table
mantis_custom_field_table
mantis_project_category_table
mantis_project_file_table
mantis_project_hierarchy_table
mantis_project_table
mantis_project_user_list_table
mantis_project_version_table
mantis_user_table
mantis_filters_table
mantis_sponsorship_table
mantis_news_table

In addition i have buit in support for the FAQ and Timetracking module.

If there are testers available, please let me know.

Cas

Posted: 09 Jan 2007, 08:00
by peterbug
I'm looking to merge two mantis instances and would love to get a copy of your scripts so I don't have to reinvent the wheel. Can you attach them to this bug or email them to me? I'll be happy to do some testing on them.

Thanks,
Peter

Posted: 09 Jan 2007, 18:48
by cas
You can find the scripts here http://www.mantisbt.org/bugs/view.php?id=7229

Still would like to receive comments etc..

Cas