MySQL jira home export
--------------------

1. Create a database
https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL
DROP DATABASE jiradb;
CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;

2. Download a standalone version of JIRA
https://www.atlassian.com/software/jira/download-archives\
Version: 6.3

// extract and set home directory
unzip atlassian-jira-6.3.zip
cd atlassian-jira-6.3-standalone/
mkdir home
echo "jira.home=`pwd`/home" > atlassian-jira/WEB-INF/classes/jira-application.properties

// db driver
download
https://maven.atlassian.com/service/local/repositories/central/content/mysql/mysql-connector-java/5.1.34/mysql-connector-java-5.1.34.jar

cp mysql-connector-java-5.1.34.jar lib/

// start jira
bin/start-jira.sh

// configure db

// insert following license
 

// admin details

Full name: Administrator
Email: admin@example.com
Username: admin
Password: admin

// notifications
don't configure email options

// finally the dashboard shows up

// stop JIRA

// execute following queries to set relative paths:
UPDATE propertystring SET propertyvalue = "./data/attachments" where ID = (SELECT ID FROM propertyentry where ENTITY_NAME = "jira.properties" and ENTITY_ID = 1 AND PROPERTY_KEY = "jira.path.attachments" AND propertytype = 5);
UPDATE propertystring SET propertyvalue = "./export" where ID = (SELECT ID FROM propertyentry where ENTITY_NAME = "jira.properties" and ENTITY_ID = 1 AND PROPERTY_KEY = "jira.path.backup" AND propertytype = 5);

// Do a db export
mysqldump -uroot -p jiradb > jira_63_mysql55_dump.sql
