restore stash to other environment (Integration plattform)

Hi

We are creating our stash integration platform, for testing changes before we implement them on production.

We would like to restore most of the data from production to this system and a hand full of repository, most, because we do not want to restore i.e. directory settings or application links.

So we made a Database backup and are trying to restore some single tables, but because of a missing DB schema we do not really know which table we need.

Actually we restore the following tables:

project.sql
sta_normal_project.sql
repository.sql
sta_activity.sql
sta_repo_activity.sql
sta_pr_activity.sql
sta_pr_comment_activity.sql
sta_pr_diff_comment_anchor.sql
sta_pr_merge_activity.sql
sta_project_permission.sql
sta_pr_participant.sql
sta_pr_rescope_activity.sql
sta_pr_rescope_commit.sql
sta_pr_rescope_request.sql
sta_task
sta_comment
AO_BD73C3_PROJECT_AUDIT.sql
AO_BD73C3_REPOSITORY_AUDIT.sql

Most works fine, but we have some trouble with the pull request view.

How do other handle this?

 

Thanks

Martin

1 answer

1 accepted

Hi Martin,

We recommend you do that by backing up Stash on the production server and then restoring it on to the Integration server using the backup client. Have a look at the docs below. This methodology is detailed and should work:

This will though restore your production directory settings or application links – which you can remove once it is up and running.

I hope it helps.

Best,
Thiago 

Suggest an answer

Log in or Join to answer
Community showcase
Piotr Plewa
Published Dec 27, 2017 in Bitbucket

Recipe: Deploying AWS Lambda functions with Bitbucket Pipelines

Bitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda&nbsp...

637 views 0 4
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot