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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

763 views 23 12
Join discussion

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