setting sandbox

[HaRsHaS' V]

I am trying to connect my Jira sandbox account to a new database. I haven't created  any data in it. Currently using default database. I want to move to mysql, I installed everything. will changing the dbconfig.xml file, make the change? Using Linux

[Nic Brough -Adaptavist- · Accepted solution]

No, you need to do an export and import as well, if you want to keep anything.  Just repointing the dbconfig file will make a mess, because you've got data in the home directory but no matching data in the database.

I would run a backup of your current system (export to xml), then install a new, clean Jira server entirely, pointed at the mysql database, get it running and log into it, then use "import from xml" to restore your old data.

[Danno]

@Nic Brough -Adaptavist-once again I've stumbled onto one of your answers that is close to what I need to do.

Can you tell me if it is possible to export a project that has been modified in the site sandbox and then import it back into the main site?

[Nic Brough -Adaptavist-]

Yes, but you'll need to do a full export and then import only the project you want, there's no "export project" really.

[Danno]

OK, so maybe I'm going down the wrong path here. My original intent was to take an existing project to the sandbox, make some changes without screwing up an active project, and then be able to migrate it back into the working site. Since I had never done this before I didn't realize what I was up against once I finally got it working the way I wanted. Am I overly complicating things here. Is there an easier way to deal with sandbox changes?

Since I don't know enough yet about the inner workings I'm thinking that this isn't for the faint of heart. I've made changes like adding components, an issue type, added fields and probably will finish with a workflow scheme (still mad I can't have a second type of Epic. 😣) and I thought I might be able to do this using the Jira Cloud Migration Assistant and following those instructions. https://confluence.atlassian.com/adminjiraserver073/restoring-a-project-from-backup-861253833.html 

Is this what I would have to do? I realize I would have to migrate it during downtime (Read late at night or weekend) if that's the case.