How do I Manually Change The Base URL
This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Functional differences in Atlassian Cloud, the contents of this article cannot be applied to Atlassian Cloud applications.
You may come across situations where you're unable to edit the Base URL through the UI. This article walks through the process of updating the Base URL through the database. An example error in the UI
"Your session has expired. You may need to re-submit the form or reload the page."
Manual manipulation of the database can be dangerous. Please make sure you have a backup of your database before you attempt these changes.
You can retrieve the base URL from the propertystring table:
select propertyvalue from propertyentry PE join propertystring PS on PE.id=PS.id where PE.property_key = 'jira.baseurl';
update propertystring set propertyvalue = 'http://jira.servername.com' from propertyentry PE where PE.id=propertystring.id and PE.property_key = 'jira.baseurl';
update propertystring, propertyentry set propertystring.propertyvalue = 'http://jira.servername.com' where propertystring.ID = propertyentry.ID and propertyentry.PROPERTY_KEY = 'jira.baseurl'