Redmine: a trick to import data from Mantis

Print Content | More

Today I decided to give Redmine a try as my new project management and bug tracking solution, mainly cause I wanted to try its integration with Subversion (given the fact that setting up an integration between Mantis and Subversion is a really painful).

To make things short I installed the Bitnami Remine Stack, then I started to face the problem of how to import the data I had in Mantis, the official documentation for the full migration can be read here.

I tried to follow it but it didn’t worked for me at start, I had to do some more things in order to make it work:

  1. Navigate to your installation folder, in my case “C:\Program Files\BitNami Redmine Stack” and use “use_redmine.bat” to open the command prompt
  2. inside the command prompt navigate to “C:\Program Files\BitNami Redmine Stack\apps\redmine” you have to launch the import script from there for it to work correctly.
  3. Before launching the script you have to figure out your “environment”, for a default Bitnami istallation it is set to “production”.
    If you set up the Redmine installation by yourself you already have this data available. Otherwise you can check your available environments looking at this folder: “C:\Program Files\BitNami Redmine Stack\apps\redmine\config\environments”, you can have different environment there, but only one is valid, that is: it has a database associated with it. To identify it you can open the database configuration file: “C:\Program Files\BitNami Redmine Stack\apps\redmine\config\database.yml” and for each environment you can see the related database.
    Now you just have to look in the mysql database folder “C:\Program Files\BitNami Redmine Stack\mysql\data” and you’ll see the valid database defined (in my case bitnami_remine, which corresponded to the production environment).
  4. Here’s the tricky part! Before launching the script you have to find a way to reach you current Mantis database, setting up remote access to a MySql database involves several steps; and even if you do so sometimes the importation script fails anyway to connect to the database; it took me a couple of hours of tries before finding this simple workaround: copy the whole mantis database folder from mantis’ MySql\Data to Redmine’s MySql data folder.
    In this way you are ‘mounting’ a mirror of the mantis database inside the redmine mysql instance.
    Be careful: you only have to copy the single database folder (usually called mantis), leave all the other system folders as they are.
  5. You can now launch the script as it’s stated in the documentation:
    rake redmine:migrate_from_mantis RAILS_ENV="production"
  6. Then the script will ask you for your database setting, leave all blank but the following field:
    1. Database: set it to ‘mantis’ (or whatever your original Mantis database was called).
    2. Password: set it to the password for the root mysql user (it will be setted as the same password you gave to the administrator user of Redmine; you can check it also looking the the default configuration file fo mysql: “C:\Program Files\BitNami Redmine Stack\mysql\my.ini”).
  7. There you go, now your data will be imported.


Import, Mantis, Migration, Redmine

1 comments

Related Post

  1. #1 da Louis Antoine - Saturday March 2010 alle 01:15

    Hello, For those who (like me) would be interested in importing a Mantis 1.2.0rc1 database into Redmine without tearing their hair out, here is a very simple howto: http://www.webismymind.be/page/fr/17/migrate-mantis-120rc1-to-redmine.html

All fields are required and you must provide valid data in order to be able to comment on this post.


(will not be published)
(es: http://www.mysite.com)