Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

How to export a space using SQL query

How to export a space using SQL query

2 comments

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

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 

Hi @Hayath_Khan_K ,

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

Export/import Space Tool

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!

Comment

Log in or Sign up to comment
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

480 views 24 9
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you