My MySQL database is gone

Question

Hi.

I installed Jira Software on CentOS 6 server.

And the MySQL database, called 'jira' is created and connected to Jira Software and it was working successfully.

I started to sync Jira with Azure AD using SAML. It works yesterday very well.

Today, I noticed that my MySQL DB 'jira' is removed, or I can't find it after I run 'show databases;' in mysql prompt.

Where is my DB. Is it removed. Why.

Waiting your response.

Nic Brough -Adaptavist- · Answer

You need your database administrators to not drop the database.  That's something you'll need to take up with them

Sobhy Admin · Answer

Thanks a lot Nic.

How can I protect my MySQL database that connected to Jira Software.

Is there any guides for this article.

Nic Brough -Adaptavist- · Answer

By "wiped" @Lenin Raj  is saying roughly the same as I did - a database process or person has removed all the data from the database.

(I've said "dropped" rather than wiped because I tend to think of "wipe" meaning "remove all the tables and data, leaving an empty database", and "drop" to mean "remove the database in its entirety".  You said "show databases" does not show the database at all, so I chose "drop" as it looks like the whole thing has gone)