Converting from Derby to MySQL

Yes. The properties look ok. But you seem to have existing tables in your mysql schema. You'll need to drop those first, and then try starting up again.

Hey friends,

I did this using Squirrel SQL, this software bring a plugin that let you copy a table from a derby database and paste that table on MYSql database, so you can export/import copying the tables from one database to another. its helpful .

Maybe not as helpful as you think. Mango will do all of that for you. You just need to create a schema for it to use, and Mango will copy over everything from Derby to MySQL for you.

gus wrote:Hello, I am having trouble converting to MySQL - I have tried all the above and no success - I am running version 1.12.4. Logs as follows:

un 9, 2011 2:05:30 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Jun 9, 2011 2:05:30 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
java.lang.IllegalArgumentException: No enum const class com.serotonin.mango.db.DatabaseAccess$DatabaseType.MYSQL
at java.lang.Enum.valueOf(Enum.java:214)

I had the same problem: I solved this removing the trailing spaces at every lines of env.properties

in my file (probably after a cut&paste from somewhere) I noticed that:
my db.type=mysql was ->> db.type=mysql[space][space]

after deleting the trailing spaces from every lines (I noticed the same problem on username/password and host)the conversion process worked like a charme!
I hope this could help someone else.

Regards