How to update Jira title from database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article shows the steps to update the Jira title (⚙️ → System → GeneralConfiguration → Edit Settings → Title) directly from database.
Environment
Tested in 8.20.11 but should be applicable to any Jira 8 and 9 version
Solution
It is possible to update the Jira title from the database, follow below steps:
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- Stop JIRA. Open the database and run the following :
Run this SQL to fetch the id from propertyentry table:
select * from propertyentry where property_key='jira.title';3. Please take note of the *id* values from step 2
4. Run this SQL to fetch the existing Jira title.
select * from propertystring where id=xxxxx;
(i) Replace xxxxx with the *id* from step 2
5. Run this SQL to update the new Jira title.
UPDATE propertystring SET propertyvalue='<New-String-value>' WHERE id=xxxxx;
(i) Replace xxxxx with the *id* from step 2
6. Start JIRA