Hi I am busy migrating our current JIRA server, App as well as Database to a new server. Steps I followed
Now I need to be able to see the messages and attachments that has been stored in the database and backed up directories but are unable to see this, I don't want to use the xml import function as I keep running into java heap memory errors, (even increasing java and tomcat maximums this makes no difference)
Your assistance will be appreciated
Regards
Anton
If you cant beat them...
So I managed to rather use the .xml import funtion to restore the database / system
What did I do differently? Initially when doing the import I ran into java heap memory size errors, I increased the minimum and maximum sizes in the setenv.bat file (JIRA bin directory). BUT I kept getting these errors, the import will get to 90% and then bomb out.
What I did is to stop the Atlassian JIRA service, installed by default in Services, under Administrative Tools, and rather start the services in the JIRA installation directory.
And low and behold the import completed successfully.
The reason for this is that JIRA was now actually recognising my installation directory as my CWD or Current Working Directory as appose to the default CWD (c:\windows\system32) and was now actually using the java set in setenv.bat
Stoked, but still not convinced migrating without .xml import is actually possible
Don't trust JIRA configuration Tool and double check the connection settings in dbconfig.xml
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Since database is in different place, you should update database connection in step 5.5. If starting jira asks you for basic settings and license key - you did something wrong. I believe - with this migration method - it should start on login screen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andris, I am using the JIRA configuration Tool to set the database connnection to point to my new database, so it is definetely pointing to the right database. I am not sure what I am doing wrong, but I am ending up at the basic settings and license key screen, and needless to say when logging in I cannot see any of my projects.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please double check your path to jira home directory. It may be case sensitive. Or maybe you extracted in subdirectory. For example, in config you have /home/atlassian-data, but you extracted it in /home/atlassian-data/atlassian-data
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andris, the JIRA home directory is exactly the same as on the current server.
C:\Program Files (x86)\Atlassian\Application Data\JIRA
Out of desperation I have uninstalled JIRA completely, reiinstalled following the above mentioned steps again.... BUT I am still ending up at the setup screen with NO projects or user data, or anything for that matter indicating that I am connected to the newly restored database.
All forums explain how to import usings xml , but not ONE properly explain how to migrate and restore using MSSQL or other external databases. Please assist if you can this is very annoying.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.