use HSQLDB or MYSQL

[basd]

Hi have been using op km from version 4.1, no using 6.2.3
I use the default HSQLDB.

No i have 2 question
1:
My problem is that don't know how i can execute an SQL query to HSQLDB from my ubuntu server.
Voor example "DROP TABLE OKM_OMR;" to upgrade to 6.24

I some can tell how i query that HSQLDB that would be great !

2:
I know mysql is mutch easyer to manage am i right, (i have alot more knowlage of mysql)?

So is it beter to migrate to a mysql database ?
if yes how can i do that ?

[jllort]

1- before stopping OpenKM you can execute sql command from administration database query.

2- I suggest use mysql. For doing it you should export all repository ( http://wiki.openkm.com/index.php/Repository_export I suggest with uuid, metadata and history), some tables like users and roles and then change to other clean installation with mysql where to import repository (http://wiki.openkm.com/index.php/Repository_import) and restores user and role tables ( to see how doing table export from 5.x to 6.2 migration guide we made something about it http://wiki.openkm.com/index.php/Migrat ... .11_to_6.2 take a look first tre slq queries to extract users and roles, in 6.2 will be similar, take it as example )