I am trying to migrate from the internal DB to MySQL. I'm on Windows. I followed the steps to backup to XML. When I try to import my data again, Jira says "You must enter the location of an XML file."
Things I've tried:
No matter what I try, I keep getting "You must enter the location of an XML file."
Edit: I also managed to get locked out. Jira said that it was already setup. What can I do to get back in?
Alright - so here's how I solved this. I setup Jira as a fresh install. Once I got logged in, I attempted an import using the zip I created when I backed this up. When I imported from the fresh install, I got an error that was actually helpful. A comment had a smiley in it (☺) and I had to go into the activeobjects.xml in Notepad++, delete it, re-zip the files, then importing it and it successfully uploaded. I don't know if this is a bug, but it might be. Seems a little strange I got an error completely un-related until I did a fresh install of Jira. Thanks for getting me on the right path though!
ah, Thanks for clarifying. It's a known limitation that mysql databases cannot store 4-byte characters. Hence characters like emojis can't be stored in those databases. This is something that looks like it might get fixed in the next major version of Jira per https://jira.atlassian.com/browse/JRASERVER-36135
Two things I would check:
Yep, it only has one extension. Extracted it and the two files activeobjects.xml and entities.xml are in there.
When I import the zip file, I see it go to a screen where it looks like it's extracting the files. But I've seen it disappear after a random percentage (could be 20%, could be 2% - it varies each time I do this).
I'm starting to get behind on work. Could I just setup Jira as a fresh install and then restore from the latest automated backup zips?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events