Find Jira database location

[Miroslav Denkov]

I've been plannning to upgrade our Jira/Confluence server to newest version that requers at least mysql 5.7 (currently running mysql 5.5, host is Windows Server 2016).

I made the mistake to use mysqldump script: mysqldump.exe -u user --password=mypassword -A -R --events --triggers --single-transaction > "E:\my_location\Atlassian_Database_backup.sql"

I removed mysql 5.5 and installed 5.7 and imported my .sql file only to find out that I only have the Confluence database and I am missing the Jira database. The Jira server is up and running but of it says that it cannot connect to the db. I still have the original files (both from the mysql origin installation directory and the Atlassian apps folder). 

My question is, how and what tools can I use to locate the other database that I am missing, I'm sure It's there somewhere but I can't find it for now.

Thank you.

[Nic Brough -Adaptavist- · Accepted solution]

Log into the database server with a client tool, as a superuser, most will show you a list of all the databases it holds.  Even the command line "mysql" will be fine - the command "show databases" will list them all.

If you can't do that, or you confirm that you are missing the Jira database then you will need to restore the mysql 5.5 installation and get the old databases back from the old installation, then export all of them.  Then you'll be able to upgrade to 5.7 and re-import the databases.

[Miroslav Denkov]

Hello Nic,

Thank you for the answer, I rolled back the backups of my mysql root folder, started manually the services and saw the attached databases!