Merging Mantis databases (Mantis version 1.2.X)

Suppose you have multiple Mantis installations and you would like to combine them.
Then you are in trouble since there is no automated procedure.

This is why I developed a few scripts in order to automate this process as much as possible.

How does this work ?
0. Ensure installations are on the same version
1. Make a backup of your current database
2. Make a copy of the Mantis database tables you would like to merge
3. Copy these tables into the original mantis database with a different prefix
	So if they are called mantis_bug_table, copy them as mexico_bug_table
4. Copy the scripts in the root of your Mantis installation
5. Transaltion can be made within import_instance_text.php
6. Logon to Mantis with Admin rights
7. Run program import_instance_page.php
8. Follow instructions
9. Verify results
10. Remove the scripts

Users and custom fields are synchronized.
The bug_history table is done in parts of 5000 records (to avoid time outs).

These scripts also have support for the FAQ and Timetracking plugins.

Please verify the max execution time in php.ini and the possible cgi time out value (under windows)

Tables that are being 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_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

mantis_plugin_timetrack_timelog
mantis_plugin_faq_results_table

