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

Stash backup and restore

We are using the backup client to back up the File system and the Oracle database.

When I want to restore I will be using another server, do I also have to set up another Oracle schema user, or can I restore to a local database?

4 answers

1 accepted

0 votes
Answer accepted

answered

0 votes
Timothy Community Leader Jul 08, 2014

You can do either.

Is this with the override settings? How do specify a local DB on the restore server?

##################################

# Restore properties

##################################

# Optional. Enables overriding JDBC settings during the restore so that the restore can target a different database to

# the one that was backed up. Even if the other JDBC properties are defined, if this property is not set to true the

# JDBC settings will be ignored. If this is set to true then ALL of the following JDBC properties must be supplied.

#jdbc.override=true

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC driver to use during restore.

#jdbc.driver=

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC URL to use during restore.

#jdbc.url=

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC user to use during restore.

#jdbc.user=

# Optional. Ignored if jdbc.override is not set to true. Overrides the JDBC password to use during restore.

#jdbc.password=

0 votes

Mike,

Please have a look at the Stash backup client documentation at https://confluence.atlassian.com/display/STASH/Using+the+Stash+Backup+Client. It contains screenshots and examples of how to do backups and restores.

Cheers,

Michael

Is there an example where the JDBC connection is to the builtin database on the restore server, i.e. The Stash built-in database, which runs HSQLDB,

you'd have to set

jdbc.driver=org.hsqldb.jdbcDriver

jdbc.url=jdbc:hsqldb:${stash.home}/data/db;shutdown=true;hsqldb.tx=mvlocks

jdbc.user=SA

jdbc.password=

But please note that this will restore the database to HSQLDB, which is an in-memory database. If you have a lot of data, you may need to increase the memory settings for Stash.

Thanks, that's what I was looking for, I'll test that out.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bitbucket

Powering DevOps with Bitbucket Server & Data Center

Hi everyone, The Cloud team recently announced 12 new DevOps features that help developers ship better code, faster   ! While we’re all excited about the new improvements to Bitbucket ...

1,505 views 0 6
Read article

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