How can I export all my JIRA issue and worklog data?

[Graham Meaden]

I want to export all my data into a database for use in an analytics and reporting tool.  What is the easiest way?

Is there a published schema? 

[Nic Brough -Adaptavist-]

The JIRA data is quite complex and a lot of the relationships are logical.

If you use the provided UI and external calls as designed, you can get sensible information out of it.  Reading the database to do this is pretty much a joke, because you have to recreate all the logical relationships.

You would be better off skipping "export into a database" and using the REST interface to ask sane questions.  Or better, do the reporting in JIRA.