Confluence - how to backup database

When I installed Confluence on Windows, I didn't install MySQL or any other database. How do I backup the current db? Is it Sqlite? 

 

 

2 answers

This widget could not be displayed.

There are many answers to this question. Using the build in confluence backup is one approach. Not advisable if the instance is large though. 

If its a Confluence instance worth doing backup on I would advice moving your production site to Postgres. Doing that is a pretty straight forward approach.

  1. Install a new confluence server with Postgre as DB
  2. Do a complete backup of your current env
  3. Restore the backup on the new env.

Atlassian has plenty of documentation regarding this that could be helpful. 

Perhaps the easiest way to solve this is doing a complete backup of the server since if the database in conjunction with the confluence data needs to be and exact match. If not you might end up with corrupt DB data and that is a mess to clean up

Cheers

Per

We're still using a trial edition; that's what we plan to do when we "go live" with an actual licensed edition. So it's a pretty small database as it is.

Do you have a recommendation for backing it up now? Currently we don't have a DBMS like Postgres or MySQL; I just chose defaults when we installed it. 

 

 

I would not recommend it but you can backup the whole server using the built in backups in your case. It takes a complete backup that can be used for restore purpose. You can find it under http://your.confluenceserver.com/admin/dailybackupadmin.action 

//Per 

Thanks. Like I said, we'll eventually go with a real DBMS once we purchase Confluence.

This widget could not be displayed.

Look at the "system information" page, that will tell you what the database is.

It is probably hsql though.  You should migrate to a proper database, as hsql can fail without warning or backup.  To do so, see https://confluence.atlassian.com/doc/migrating-confluence-between-servers-184150.html

Sure, we plan on using a real database system when we go live. Currently we're using a trial license but we've added some actual content. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

447 views 5 6
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