nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to backup JIRA? (w/ MySQL instance)

Tobias Hoffmann1

Hi there,

i have successfully setted up my JIRA Starter Edition on a Windows 10 machine, within an own MySQL server instance (v5.7) running.

Now i am struggling in how to manage the Backup. How can i save the DB? Which directories of JIRA should be backed up?

Looking forward to your suggestions. Thanks!

tobi

Accepted answers

All comments

Jonas Andersson

I would back it all up, as they contain all kinds of config-files, java keystores, addons and attachments so if installed in c:\atlassian\jira\ and c:\atlassian\application-data\JIRA i would back both those up. The database is backed up using:

mysqldump.exe <databasename> -u<username> -p<password> > c:\jira.database.sql

Not huge on windows mysql nor windows Atlassian deployments, so your paths most likely differ.

Tobias Hoffmann1

Hey Jonas,

thanks for the fast answer! Yeah they differ indeed but i already found the correct ones. Do i have to add anything before the mysqldumb.exe line? stopping the database or isnt it necessary?

Regards

Tobias Hoffmann1

If i do the mysql dump the .sql file is 0kb.

but should be >6MB

Joe Pitt

Why aren't you using the built in backup process?

Tobias Hoffmann1

it doesnt save the DB?!

Joe Pitt

It saves ALL the data and configuration. I don't understand the distinction? It doesn't save attachments, but they aren't stored in the DB.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-administration