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.
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
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)
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.
You just undo the changes in the database config file that swapped you from hsql to mysql. It'll start reading the files that you left behind (if you've got data in mysql, that's a whole different question probably, because you're getting into extract, merge, update etc - the swap back to hsql really is "go back to where I turned it off") That is only a temporary change right? You're not thinking of using HSQL for actual data in the long run?
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
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
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!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot