{{tag>atlassian jira}}

====== Migrate Jira to new server ======

===== Setup mysql =====


   wget https://dev.mysql.com/get/mysql-apt-config_0.8.11-1_all.deb

   dpkg -i mysql-apt-config_0.8.11-1_all.deb

==== Create jira user: ====


   CREATE USER 'jiradbuser'@'localhost' IDENTIFIED BY '<password>';

   GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on jiradb.* TO 'jiradbuser'@'localhost' IDENTIFIED BY '<password>';

   FLUSH PRIVILEGES;

Make sure above matches in /var/atlassian/application-data/jira/dbconfig.xml.
===== Zip up jira data directory and make database backup =====

   tar cjvf jira_install_dir_$(date +%F).tar.bz2 /opt/atlassian/jira/
   mysqldump -u jiradbuser -p --databases jiradb > jira.sql

On new server unpack the jira data dir and restore DB:

   mysql -uroot -p evojira < jira.sql
   tar vxf evojira_2018_12_07_1417.tar.gz -C /

===== Install apache and enable apache modules =====

   apt install apache2
   a2enmod rewrite ssl proxy proxy_http

Enable ssl. See [[wiki:jira_ssl_apache2_configuration|Jira ssl apache2 configuration]]
===== Install jira and mysql connector =====

   wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-7.3.5-x64.bin
   wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.41.zip

===== Run installation =====

   ./atlassian-jira-software-7.3.5-x64.bin


===== Copy java connector plugin =====

   apt install unzip
   unzip mysql-connector-java-5.1.41.zip -d .
   cp mysql-connector-java-5.1.41-bin.jar /opt/atlassian/jira/lib

===== Start jira =====

   /etc/init.d/jira start