# How to update an Application Link URL manually

#### Still need help?

The Atlassian Community is here for you.

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.

## Purpose

There are times where you'll need to update an Application Link in Confluence to use a different Application URL and Display URL without re-creating that link.

Generally speaking, you should not need to re-create the application links unless a specific problem prevents you from using the application links interface.

## Solution

• Shut down Confluence if it's running
• Perform a full database backup

SELECT * FROM BANDANA WHERE BANDANAKEY LIKE 'applinks%url';
• For each application link you'll have two records - one for the application link URL and one for the display URL - for example: <string>http://localhost:8080/jira</string>
• You will need to update the URL to your new address, using the ID you gathered in Step Three (3):

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.

UPDATE BANDANA SET BANDANAVALUE = '<string>newURL</string>' WHERE BANDANAID = xxx 

Replace newURL with the new Application Link URL, and replace xxx with the ID of the rows you wish to update from Step Three (3)

• Restart Confluence, and verify that your application link is correctly pointing to the new instance.