working instance switch to mysql

[silverspr]

Hello
I now have a working instance of OpenKM in windows 8.1. Now I want to switch the database to mysql. I don't want to re-install OpenKM. If I delete the current repository and configure OpenKm for mysql i.e. hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.hbm2ddl=create

I should be good to go? I guess I could try and post back!!

thanks everyone

[jllort]

First of all there's no magic button, or similar thing to move from one database to other. The way for doing it is:
1- Do a backup ( copy entire tomcat folder -> if you are using default installation with embeded database, then copying folder you get all )
2- Export all repository data ( Administration -> export ( I suggest check all checkbox ) http://wiki.openkm.com/index.php/Repository_export
3- I suggest you execute some sql to get users and roles, get inspiration on some query you can found here http://wiki.openkm.com/index.php/Migrat ... .11_to_6.2
4- Set hibernate.hbm2ddl=create ( you will lose all repository )
5- import data ( first categories, and then the others, with same checkbox selected as you've done while exporting ). http://wiki.openkm.com/index.php/Repository_import