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; } } }

Database is not Empty issue

Nagaveer

Before I was using JIRA 6.0. Now I installed JIRA 5.2.9. While Configuring database for the first time, I'm getting error.

ERROR:

You have specified a database that is not empty, please specify an empty database.

Before I was using MYSQL DB, now I want to configure with HSQLDB.

please help me

Accepted answers

Nic Brough -Adaptavist-

The fix is in the error message. It expects you to provide it an empty database. Create a new empty database for it and tell it that one instead of the one that already exists.

Or drop all the tables in the existing one if you really don't need it (of course, backup first, if there's anything you might need)

(Additionally, don't use HSQLDB if you are creating a production system. It's only suitable for dev/test and other systems where complete loss of all the data is not a worry)

All comments

Nic Brough -Adaptavist-

The fix is in the error message. It expects you to provide it an empty database. Create a new empty database for it and tell it that one instead of the one that already exists.

Or drop all the tables in the existing one if you really don't need it (of course, backup first, if there's anything you might need)

(Additionally, don't use HSQLDB if you are creating a production system. It's only suitable for dev/test and other systems where complete loss of all the data is not a worry)

Nagaveer

Thanks for quick reply Nic,

please tell me how to create new database in HSQLDB

Or drop all the tables in existing database?

Nic Brough -Adaptavist-

In HSQLDB, you can simply delete the files that lie behind it and it'll be recreated. But as you've got MySQL working and connected, I'd stick with that.

There's no easy way to drop all the tables in a MySQL database. I wouldn't bother though, I'd create a new empty one and tell Jira to use that.

Nagaveer

Thanks Nic,

Now I want to configure with HSQLDB, Can you please What are the files I need to delete?

Rahul Aich [Nagra]

dbconfig.xml

https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+HSQLDB

Rahul

Nic Brough -Adaptavist-

There's a couple of files called something like "database.script" and "database.log" in the home directory. You'll need to delete the one that appears to contain nothing but SQL statements.

You'll also need to reconfigure your Jira to read HSQLDB, start with a look in dbconfig.xml

Stefan Dangl2

What about users who want to go back to an existing HSQLDB. In our case, we tried to migrate to mySQL resulting in excessive data-loss. Going back to HSQLDB could save us a lot of time!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration