Backup and Restore Database Software for Jira / Bitbucket / Confluence

Question

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_ · Answer

@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.)

Albert Manuel · Answer

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

Thank You

Aron Gombas _Midori_ · Answer

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:

* It dumps each schema to a separate dumpfile, compresses it with ZIP and adds a timestamp to the filename.
* The results ZIP files are moved to a Dropbox-tracked dir, so that they will be uploaded to the cloud in the background.
* The shellscript also copies the backups created by the built-in Jira and Confluence features to the Dropbox dir.
* (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.