Run a new Jira CentOs instance (7.13) with an exsisting DB (MSSQL)

[testdockerhub]

Hello,

i have a Jira instance (7.4.1) with a MSSQL Server (2014Pack3).,i created a new CentOs machine and i want that machine to be the new Jira Appserver . so i made a Backup my DB and then created a new One from that backup which is a new DB but not Empty.

i want to connect it with my new Jira instance (7.13) ,whats the best practise that i can Do for that, to find all my DATA on my new instance .without any risk of Data loss

Thanks .

[ajeet_singh]

Hi @testdockerhub,

After installation of new jira instance you need to import your old data to new Jira instance .

to do so, you need to export old  jira back and import to new jira instance 

after export you find file in <Jira_home_directory>/export/export.zip

then you need to copy export.zip, attachments,avatars

from old jira data <Jira_home_directory>/data/attachments

                                      <Jira_home_directory>data/avatars

                                     <Jira_home_directory>/export/export.zip

copy To

new JIRA data <Jira_home_directory>/data/attachments

                       <Jira_home_directory>/data/avatars

                       <Jira_home_directory>/import/

after copy attachments,avatars and export.zip file start your new jira instance then

 Administration->system->restore jira

give the export.zip file name and licence key, the click to restore ,

[testdockerhub]

thanks @ajeet_singh for your answer..,but its not a small instance so i will not an XML File to backup, i will make a backup on the  MSSQL Database itself and then connect it to my new instance.

but im not sure if i will get all my files and attahcment because i saw some pages that they mention to change some files on my configuration to make it work correctly and can view all my documents and attahcment that i had

[ajeet_singh]

@testdockerhub,

before start first time your new jira instance,

1. create new DB,   and restore you old db dump to new db,

2. copy old  <Jira_home_directory> to new system and update the dbconfig.xml to point to new database ,

3.update <jira_app>/atlassian-jira/WEB-INF/classes/jira-application.properties 

4. start your new jira instance ,

[testdockerhub]

wow thats exactly what i was confused on ...,Thanks a Lot @ajeet_singh..,i do not know how i can thank you..

Just a small Detail if it is possible ,im not sure that i understand your last point ..,can you explain it more !!! or maybe a usefull link that explains it !!!!!

.update <jira_app>/atlassian-jira/WEB-INF/classes/jira-application.properties !!!!!!

Thanks

[ajeet_singh]

jira-application.properties file  have configuration of <Jira_home_directory>, so you need to update according to your new <Jira_home_directory> 

[ajeet_singh]

https://confluence.atlassian.com/adminjiraserver/setting-your-jira-application-home-directory-938847747.html

[ajeet_singh]

https://confluence.atlassian.com/doc/restoring-data-from-other-backups-148627.html

[testdockerhub]

Thanks @ajeet_singh...,i guess that it will be the same steps for doing the same thing with a Confluence instance !!!!

[ajeet_singh]

Yes @testdockerhub, most probably same settings in Jira and confluence to update  application home_directory

[testdockerhub]

Thanks @ajeet_singh, for all those valuable informations .