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 vote
Timothy Chin Community Champion 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 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

71 views 0 11
Read article

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