How to export a space using SQL query

Hayath Khan K August 19, 2019

How to export a space using SQL query

2 comments

Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 19, 2019

Hello @Hayath Khan K ,

Confluence's spatial export is based on XML, HTML and PDF. I don't understand what you mean by SQL querie.

TIM截图20190820145334.png

Hayath Khan K August 20, 2019

Hi ollie,

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 ?

 

regards,

Hayat 

Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 20, 2019

Hi @Hayath Khan K ,

It looks like this is an unreleased feature, you can vote for it.

Export/import Space Tool

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 20, 2019

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.

Mark Bereznitsky
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 20, 2019

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!

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events