How can I change the field value in mysql jira ?

dima slobodyanyuk August 18, 2015

I need change field value in database JIRA (mysql). How can i do this ?

2 answers

1 vote
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 18, 2015

Michael has given you the link to the SQL, but it is absolutely critical that you understand the full process.

You absolutely must:

  • Stop JIRA
  • Take a full backup of the database
  • Apply your SQL
  • Restart JIRA
  • Re-index it

Never never never write to an active JIRA database - in many cases, you'll be lucky and just end up with minor corruption of the index which can be fixed, but you can end up with a corrupted and irrecoverable database.

(On the last point about re-indexing, if your changes are limited to a known set of issues, you can just use project re-index or even just an edit of the affected issues.  But you must reindex them somehow)

0 votes
michael_ngangom
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 18, 2015

Hello Dima,

Check this

Suggest an answer

Log in or Sign up to answer