nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

H2 Embedded DB to MySQL

Alexander Badich

Good Afternoon,

I have been having some issues on switching DBs... H2 to MySQL

-I'm running H2 on Jira version 7.5, and I want to move my instance to MySQL.

I been referencing these articles to help me but I am feeling there must be a faster and smoother way to migrating to MySQL.

https://confluence.atlassian.com/adminjiraserver075/connecting-jira-applications-to-mysql-935390852.html

https://confluence.atlassian.com/adminjiraserver075/supported-platforms-935390828.html

https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html#Switchingdatabases-differenttype

Could I please get some more help?

Thank you!

Accepted answers

Nic Brough -Adaptavist-

Those documents give you the fastest and smoothest way to migrate between databases.

All comments

Nic Brough -Adaptavist-

Those documents give you the fastest and smoothest way to migrate between databases.

Alexander Badich

Nic,

Thanks!

Alexander Badich

Nic,

I must of have done something wrong. I finally setup MySQL, and was able to edit the dbconfig.xml. After turning on Jira Service it populated the "jiradb" database and was fetching tons of data. I rebooted and I cannot sign into MySQL with my newly created account or my root. It says I cannot connect to localhost anymore.

Now it acting like there is not data in my jiradb? I cannot cannot to MySQL with workbench with any of the credentials I used to set it up?

Can you please guide me!

Nic Brough -Adaptavist-

That would mean that either MySQL is not running on the current machine, or you have set the security to not let you in.