Python Script to port Bugzilla MySQL to Mantis PostgreSQL

[cwp]

I just ported our old bugzilla database hosted in MySQL to Mantis hosted
in PostgreSQL. Since it took a couple days to put together the script for the
port, it may be worth sharing. I took a look at Agusti Fontquerni's
bugzilla2mantis.php script. It was a helpful roadmap but didn't dig out all
the information that I wanted, nor did it "hook in" to the new project layout.

The program copies all of your attachments out of MySQL and
creates an sql file that you can feed in, via pgsql, to port the database.
In addition to the items handled by bugzilla@mantis.php, bug history is
ported as well as attachments.

The basic working mentality is that you generate the users, projects,
categories and versions by hand, and then run this script to map all
your old bugs and bug history.

It could definitly use some polishing, (nice command line args, simultaneous
connection to PostgreSQL to check for sequence number conflicts, etc. )
I won't be maintaining it but anyone else is welcome to do so.

Instructions and script are at: http://www-pw.physics.uiowa.edu/~cwp/in ... ?bz2m_port

[vboctor]

Thanks for taking the time to post this here. It's great to see such migration scripts allow people to move to Mantis.

Several similar scripts have been posted and their websites disappear after a while. If you don't mind, it would be great if you can report an issue in the bug tracker and attach your script. It would even be great if you can create a wiki page associated with the issue and include the documentation. However, if you want to keep it only on your website, then it's ok. Although it seems that you won't be maintaining it.

[cwp]

Sure, I can make a wiki page. Does the forum login allow one to create wiki
pages as well?

[vboctor]

The bug tracker login allows you to login to the wiki too. Once you create an issue, I'll create the wiki page for it and then you can edit it.

[xanadu1215]

Hi
I was converting to Mantis and am attempting this conversion.
But part of the instructions are vague.
I ran the php file, received the message: DELETE FROM mantis_user_table;
It seems like there shoulkd be more...no i'm kidding of course there shoul d be more. Any help is appreciated if you have run across this.
Meanwhile, I'm heading back into the script.
Thanks
Steph
===
1) Backup all databases
2) Copy this file to bugzilla web site ( example: /var/www/bugzilla )
3) Modify database parameters "server", "user", "password", "database" ( 'localhost','root','', 'bugzilla' ) in "bz2m_connect()" function
4) Open "bugzilla2mantis.php" with web browser ( example: localhost:/bugzilla/bugzilla2mantis.php )
5) Check output web page
6) Select all (Ctrl+A). Copy from web browser to test editor. Save to file ( example: mantis.sql )
7) Install mantis website ( http://www.mantisbugtracker.com/ )
Modify mantis database from bugzilla data "bugzilla2mantis.php" ( example: mysql -u root bugtracker < mantis.sql )
9) Now, report bugs with mantis ...

[cwp]

You seem to be discussing Agusti Fontquerni's bugzilla2mantis.php script.
I can't help you with that one. The python script bz2mantis.py was the
kick off point for this topic.