Jira

Check version of Jira on Linux/Unix via command line

This is specifically for if you are using a MySQL database.

select * from propertystring where id = (select id from propertyentry where property_key = 'jira.version');

Update Jira

Backup the XML database: https://confluence.atlassian.com/adminjiraserver074/backing-up-data-881683990.html

Backup the dbconfig.xml file

Backup the jira/data directory

Then update either manually or with the installer:

https://confluence.atlassian.com/adminjiraserver074/upgrading-jira-applications-manually-881683261.html

https://confluence.atlassian.com/adminjiraserver074/upgrading-jira-applications-using-the-installer-881683273.html