Hi,
I’m moving jira and confluence to new domain.
In content of some tickets we had static URL which were using our old domain. Therefore I done some link replacement directly in database in all places accept "Custom Fields".
I found that those links are in table name customfieldvalue in column “stringvalue”, but there are in form of "shortcut".
i.e. when I put URL https://old.domain/confluence/x/MgKJAgin browser
It will be resolved to https://old.domain/confluence/display/KDG2013/very-long-name
So I can’ just replace in DB
https://old.domain/confluence/x/MgKJAgwith
https://NEW.domain/confluence/x/MgKJAg
Because it won’t work.
Can someone tell me how is this link (shortcut) generated, and how can I replace it for all the tickets which has set up fields with URL’s ?
best regards
Karolina
Database system usually has a REPLACE function that you can used to replace partial text in the column vaues. Here's an example of mysql: http://stackoverflow.com/questions/10177208/update-a-column-value-replacing-part-of-a-string
Otherwise, you can export the xml and replace the old domain name with replace function in Text Editor.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.