Monday, February 21, 2011

Using SQL for cleaning up JIRA database

Has anyone had luck with removing large amount of issues from a jira database instead of using the frontend. Deleting 60.000 issues with the bulktools isnt really feasible.

Last time i tried it, the jira went nuts because of its own way of doing indexes

From stackoverflow
  • How about doing a backup to xml, editing the xml, and reimporting?

    dacracot : I have had success with this method, but never had the guts to try SQL on their schema.
    svrist : The backup takes quite a while too, but this might be a usable idea
  • We got gutsy and did a truncate on the jiraissues table and then use the rebuild index feature on the frontend. It looks like it's working!

0 comments:

Post a Comment