You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
How to export a space using SQL query
if there are 100 + spaces which needs to be exported in Confluence since the above step is manual and take a lot of time to complete . Please let me know how to export a space using SQL query ?
Hi @Hayath Khan K ,
It looks like this is an unreleased feature, you can vote for it.
You can "export" a space by cross referencing the bodycontent, space and content tables. It will be utterly useless to you though, as you'll lose the metadata that makes it into a space, can't be used to create another Confluence space and leave you with the internal markup rather than useful content, and you'll lose all the structure
SQL is the worst possible thing you can do here. You really need to use the XML, HTML and PDF methods if you want usable output.
We do not recommend exporting a space via a SQL dump. Please use the built in XML exporter which will pull in all the required entities along with the dump.
If you need to migrate a larger site and are encountering errors during the export, please contact support, they are well versed in those sort of problems.
Thanks again for using Confluence!