Update JIRA look/feel and LDAP via DB script

Question

Hi,

I am on JIRA version 6.2.2 and want to create a JIRA staging environment.

I have the environment and have customized the JIRA look and feel along with pointing to a different LDAP server.

However, every time I refresh the MySQL data from prod, all my customizations get over written.

Does anybody know which MySQL values I need to over write so I can automate the setup process?

This is a bit annoying to have to update everything by hand after a DB refresh...

Nic Brough -Adaptavist- · Answer

The most important thing here - NEVER update a database while the application is running.

Alexey_Rjeutski__Polontech_ · Answer

Hi Abhi,

Most probably - you should use properties table, also cwd_directory. But as I don't know complete list of your customization - I would recommend you:

1. make the migration

2. After the migration - create database dump

3. Make the customization

4. Make database dump again

5. compare dumps - and you will get the list of changes that are needed to be applyed.