Change the default DB from H2 to Mysql

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

bsong

Initially, I started to using Activiti-app I was using the default DB h2. Right now I want to change the database to Mysql. 

I did the following configuration in the  activiti-app.properties

datasource.driver=com.mysql.jdbc.Driver
datasource.url=jdbc:mysql://localhost:8889/activiti?characterEncoding=UTF-8
datasource.username=admin
datasource.password=admin

hibernate.dialect=org.hibernate.dialect.MySQLDialect

but after the change, I restart the activiti-app there is no table created in activiti database and activiti still point to the H2 database. 

And how can I move the data from H2 to Mysql?

Thanks 

salaboy

Can you please specify which version of activiti are you using? 

hibernate.dialect=org.hibernate.dialect.MySQLDialect -> we are not using hibernate as far as I remember, so you will probably need to set up a flag to specify that the tables should be created if they don't exist.

Also check this if you are in 5.x versions: How to configure a mysql database in activiti? - Stack Overflow