Migrating openfire HSQLDB database to mysql_en.pdf

Migrating openfire HSQLDB database to mysql.

2 Likes

Thank you very much for contributing this

You should add this to your sql URL.

?rewriteBatchedStatements=‘true’

So the end result would be this

jdbc:mysql://SERVER-IP:3306/DATABASE-NAME**?rewriteBatchedStatements=‘true’**