Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

My MySQL database is gone

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.

2 answers

0 votes

You will need to talk to your database administrators.  They have either hidden it from you or removed it.

Jira doesn't have any code that might drop a database.  You have to do that at the database level.

0 votes

Hi @Sobhy Admin 

It could be that you were on a shared server instance and the database was wiped.

I don't know what do you mean by the DB was wiped.

I installed Jira Software on Linux server, and the MySQL DB installed on the same server.

By "wiped" @Lenin Raj Rajasekaran  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)

Like Lenin Raj Rajasekaran likes this

Thanks a lot Nic.

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

Is there any guides for this article.

Like Lenin Raj Rajasekaran likes this

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

Like Lenin Raj Rajasekaran likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,499 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you