Overview

Here's the process for importing a Mantis dump

MySQL Database Creation

CREATE DATABASE openxma;
GRANT ALL PRIVILEGES ON openxma.* TO openxma@'localhost' IDENTIFIED BY 'mdkbOxqr' WITH GRANT OPTION;

To launch a MySQL interface

mysql --user=openxma --password=mdkbOxqr openxma

Now import the dump

\. <dumpfile.sql>

JIRA

1. Unpack and configure a fresh JIRA instance / use an existing instance.
2. Download and copy the MySQL JDBC jar into JIRA_HOME/common/lib
3. Go to "External System Import in JIRA"

Configure the MySQL database connection

Select Mantis projects to import

Map Mantis projects to JIRA keys

Logs

Things to check

Check that all issues get statuses - the Mantis importer uses a NULL status if it can't match the Mantis status to a JIRA status!