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
JIRA
- Unpack and configure a fresh JIRA instance / use an existing instance.
- Download and copy the MySQL JDBC jar into JIRA_HOME/common/lib
- 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!