Need Help in Confluence installation

Hi ,

I recently installed evaluation version of Confluence 4.3 in MAC OS Lion.

I could see installation went fine by default thec onfluence takes the HSQL DB instead i wanted to connect to mySQL.

I changed the confluence.cfg.xml and when i reastart the server i get

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.bandana' doesn't exist

This seems to be because the DB "confluence" does not have the mandatory tables.

How can create the tables required in mySQL DB , there is a confluencedb.script in data folder but it is specific to HSQL.

Could any one please helping me in sorting this out,

Thanks in advance ,


2 answers


sounds like your installed conflunece running on hsqldb

did you already took a look at ?

Thanks for the reply,

I tried using migration assiatant but getting below error,

Could not connect to Source DBMS.
[IM002] [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) (SQLDriverConnect)

ODBC connection string: jdbc:hsqldb:\Users\Aravind_\Desktop\confluence-data\database\confluencedb;hsqldb.tx=MVCC

Copied the hsqldb.jar to /mysql/lib folder.

Copied the hsqldb.jar to /mysql/lib folder.

why this location? shouldn't it be inside your application_installDIR

i.e. mine (using linux) is located here


this dir contains the db drivers

ls -1 *sql*

Note that MacOS X is not supported as a server (check supported platforms). I recommend you to try installing it in a linux box.

I'm sorry I cannot downvote (yet)

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,770 views 26 10
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