How to import data from a MSQL database

[Diego Banhos]

Hello Team,

I was wondering how to import data from a backed up database. I have a back up from a datase and I am trying to have the same information is a different database (same MSQL version)

Thanks and regards.

[Nic Brough -Adaptavist-]

Restore the database into an empty schema, then point a development JIRA at it.  You can then use the xml export facility to get an xml dump, from which you can import projects.

Trying to convert data from a plain database dump into something you can import is a massive amount of work, and error prone, not to be recommended.