Hello,
I have update our old mantis database from Mantis 0.18.3 to Mantis 1.0.oct.
We have an other mantis Database in 1.0.oct. So we want to have the two Database in One.
We have Apache2, PHP 4.3.0, PHPMyadmin 2.3.2 and MySQL 3.23.53
Thanks
How make I from two mantis database one?
Moderators: Developer, Contributor
Here's what I woudl do.
1. update all instances of Mantis to the latest version.
2. Decide which one is the target to receive all the bugs.
3. Identify in all the databases the tables with ID fields.
4. For each table, find max_ID.
5. For each table in turn, transfer records from the source tables to the target tables, adding max_ID to each ID field.
6. Having transferred all the tables, recalculate the new max_IDs for each table.
This may be worthwhile writing a php program to do.
1. update all instances of Mantis to the latest version.
2. Decide which one is the target to receive all the bugs.
3. Identify in all the databases the tables with ID fields.
4. For each table, find max_ID.
5. For each table in turn, transfer records from the source tables to the target tables, adding max_ID to each ID field.
6. Having transferred all the tables, recalculate the new max_IDs for each table.
This may be worthwhile writing a php program to do.