Storage of tiny links on database

Hey! I would like to know, where I can find the tiny links related to each page on database?

This would be helpful for doing a manual change or exporting a space and import it to another instance.

1 answer

1 accepted

1 vote
Answer accepted

Ah, they're not stored in the database, they're generated when you view the page properties.  

I'm not entirely sure how they are generated, but I suspect it's just <confluence base url>/x/<something based on page's database id>, so if you import it into another instance, the shortcode at the end is going to change.

Hey! Thanks for your response! I think the shortcuts after the /x/ must be stored somewhere since you can copy the link and spread it to your users and all users will get to the same page when opening the link. Yet, I do not know where this information is stored. To avoid broken links after importing a space from another instance, I wondered if I can 'save' the tiny links and paste them to the new instance.

I think you've misunderstood my answer. The short code is generated when it is needed. NOT stored in the database. It is based on something that does not change (I'm pretty sure it's the page id), so it doesn't appear to change, but it's not stored and I suspect it changes when you import pages in another instance.

Okay, I thought that it has to be stored on any table, since it does not change once it is created. So, there is no way to take a backup of them and restore it :( This is very bad, since plenty of links will get broken!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,349 views 2 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you