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
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,525 views 25 14
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