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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Two things I would check:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You should not unzip the MigrateToMySQL.zip file. Just write MigrateToMySQL.zip during import.
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.