Import and exporting of a mantis instance

[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?

[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

[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/

[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

[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

[cas]

You can find the scripts here http://www.mantisbt.org/bugs/view.php?id=7229

Still would like to receive comments etc..

Cas