Bulk change of links in jira

[mliebelt]

One of our customers has added a lot of links to Sharepoint content in his JIRA project, and that Sharepoint instance has moved and is now available under a new URL. Is there a simple way to modify all the links from a source to a target? I know that there are tools available to script something like that, but this will not be an option for him.

[Jonas Andersson · Accepted solution]

Simple would be oversimplifying it (hah see what i did there? )

• Shutdown JIRA

• dump the database

  mysqldump --single-transaction --routines -uUsername -pPassword --max-allowed-packet=1G jira > jira.sql

• use linux standard tools sed to replace old vs new hostnames like:

cat jira.sql | sed 's/https:\/\/oldURL\./https:\/\/newURL\./g' | sed 's/http:\/\/oldURL\./http:\/\/newURL\./g' | sed 's/https:\/\/oldURL\//https:\/\/newURL\//g' | sed 's/http:\/\/oldURL\//http:\/\/newURL\//g' > new.jira.sql

What i do here might seem odd, but it's to make sure

http://servername/

https://servername/ 

http://servername.whatever.follows

and

https://servername.whatever.follows

All get converted to their new names (short and fully qualified, http and https)

• import the new database back

  mysql jira -uusername -ppassword < ./new.jira.sql

• Start JIRA again.