How to backup JIRA? (w/ MySQL instance)

[Tobias Hoffmann]

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

[Joe Pitt]

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

[Tobias Hoffmann]

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.

[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 Hoffmann]

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 Hoffmann]

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

but should be >6MB