Confluence Data - Trying to override existing database

This question is in reference to Atlassian Documentation: Using the JIRA application configuration tool

Clicking on upgrade (Confluence),  now i  cant connect to my database, Confluence is asking me to set up data base again when i already have an existing database.

The following error(s) occurred:

  • Confluence tables already exist in the selected database.

What will be  the best way of knowing or pointing confluence to the  right database  ?

 

Should there not be a choice to choose this from the  installation wizard ?

1 answer

0 vote

No.  What you're doing is trying to connect an unconfigured Confluence to a configured one.  It cannot know whether you need to go through the setup again or not.

Your next step should be to connect this Confluence to an empty database.

NO I am not trying to connect to an unconfigured confluence. 

Like i said Confluence was up and running before the upgrade.  After a restart on the server, Confluence went straight to the configuration page asking me to configure database. And this is why i am concerned with this action from Confluence

Every other i installed worked fine with the existing database, why not confluence ?

 

 

That's not what the system is telling you, although you've misread what I said and got it the wrong way around.

Your Confluence is not configured, as it believes it needs to set up the database, but it's trying to connect to one with data in it.  So it's complaining because it doesn't know what you want.

I have the same issue, I setup Confluence for the first time and want to setup a DB and receive the message that  Database Contains Existing Confluence Data - Confluence Confluence tables already exist in the selected database. The only thing that I have did was create manually the DB in MS Sql, I dont understand why I receive this message as i didn't create the table.

You've pointed it to a database that has already been set up by a Confluence installation.

You need to point the installer at an empty database.

and how I can override without the drop the DB?

You don't.  You need to point a new Confluence installer at an empty DB.  Either drop the tables in the existing one, or create a new empty one.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,894 views 27 12
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you