Backup and Restore Database Software for Jira / Bitbucket / Confluence

[Albert Manuel]

Hello,

I have a virtual machine under Linux where i have 3 instances: Jira, Confluence and Bitbucket, and i wonder if it's possible to backup somehow automated with software the database and restore'it in the same way.

Are there any other solutions to backup somehow automatically? My databases are Postgres.

Thank You.

[Aron Gombas _Midori_]

We are in your scenario: the same 3 Atlassian applications running on a single Linux box, using the same database (3 schemas, of course).

We have a shellscript executed as a standard Linux cron job:

1. It dumps each schema to a separate dumpfile, compresses it with ZIP and adds a timestamp to the filename.
2. The results ZIP files are moved to a Dropbox-tracked dir, so that they will be uploaded to the cloud in the background.
3. The shellscript also copies the backups created by the built-in Jira and Confluence features to the Dropbox dir.
4. (As a nicety, we have a tiny additional mechanism that checks if the expected number of files were uploaded to Dropbox, and warns if not.)

It is simple, and it just works.

[Albert Manuel]

Hi @Aron Gombas _Midori_ it is possible to share this script, without the sensitive information of course?

Thank You

[Aron Gombas _Midori_]

@Albert Manuel I could, yes, but note that we're on MySQL so it may not be very useful for you.

(Other than using "mysqlbackup", it is a couple of "cp" and "echo", no big deal.)

[Alexis Robert]

Hi @Albert Manuel , 

a database backup is the recommended procedure to save your applications data and restore it in case of disaster recovery.

I would suggest doing a backup every day with postgres dump utility, you can have a look at this documentation : https://www.postgresql.org/docs/9.6/backup.html

You should also backup the HOME folder for Jira/Confluence/bitbucket as this is where the attachments are stored, I would suggest writing a simple bash script to create a tar.gz archive daily.

Let me know if this helps, 

--Alexis