0010151: DB Converter 1.1.1 => 1.2.0a3

ID	Project	Category	View Status	Date Submitted	Last Update
0010151	mantisbt	migration	public	2009-02-23 05:26	2009-07-04 13:24

Reporter	steffel	Assigned To
Priority	normal	Severity	feature	Reproducibility	N/A
Status	acknowledged	Resolution	open
Product Version	1.2.0a3

Summary	0010151: DB Converter 1.1.1 => 1.2.0a3
Description	due to migration reasons and special migration requirements, i implemented a php db converter script. i want to give it to the community and hope it is usable for others, too. my special requirement was that we had two parallel mantis 1.1.1 systems that now are merged into on 1.2.0 system. for that reason i had to shift some IDs in the database ... but this can be configured in my script.
Steps To Reproduce	1) export your whole database into an SQL file (phpMyAdmin => export). UNCHECK extended inserts (every line has to have an "INSERT INTO")!! 2) copy the dumped file into your convert - directory and adapt the config.inc to the filename (variable $g_input_file). 3) adapt the config.inc file (see comments there) 4) commandline> php convert.php 5) the converted file will be written as specified in the config.inc $g_output_file variable.
Additional Information	example dump and converted files are attached. tested with php version 5.2.6. feel free to ask if you have any questions.
Tags	No tags attached.
Attached Files	mantis_db_converter.zip (9,792 bytes) mantis_db_converter_1.1.zip (9,849 bytes)

vboctor 2009-07-04 13:24 manager ~0022386	Thanks for your contribution. This sounds like a useful migration tool. It would be useful to include some more details about how you handle the merge. For example, merging projects, versions, users, categories, etc. Do you have certain assumptions? For example, statuses are the same?