Migrate from existing HSQL database to MYSQL

[sandeepchauhan]

we have configured OpenKM 6.2.5 and are using it for over an year now. the performance has gone really down recently and when we looked for the reason in this forum, we realized that the mistake is due to selection of default HSQL database for managing this application.

now to correct our mistake, we would like to shift to MYSQL to enhance the response time.
but unable to find any POST on migration to MYSQL.

Can anyone help us out?

[jllort]

- Well first -> do a backup.
- The nearly guide to change database is export all data and import to new openkm ( there's not other possibility ). That means :
1- set older openkm in readonly mode to be sure nobody will do changes
2- export all data http://wiki.openkm.com/index.php/Repository_export ( with metadata and history checkbox )
3- export configuration parameters ( administration -> configuration -> button at top right )
4- intall fresh openkm with mysql ( you can change ports if you want to get both running at same time http://wiki.openkm.com/index.php/Severa ... ame_server )
5- import all exported data ( with history and metadata ). First import categories if you've got someone and then the others main nodes you've exported before
6- And here are some queries to rescue users etc.. at the begining of the post that can help you http://wiki.openkm.com/index.php/Migrat ... .11_to_6.2 ( the roles name changes etc... has no sense for you, only consider migrate users and roles ). About profiles should be configured again. And restore configuration parameters you need ( do not execute the exported sql, open in editor and only execute what really you need ).

There's no magic way needs some work but after migrate to Mysql or PostgreSQL you'll see the difference

[dummy]

I follow this procedure to migrate from HSQL to MySQL in a new installation but in fact only the taxonomy structure will be exported. How to move Personal documents and emails altogether?

[pldemon]

You have to select the folder which should be exported.

1.) Go to export
2.) Klick on the folder near "Repository path"
3.) Klick "<PARENT FOLDER>"
4.) Select the exported folder

Data export
export.png (90.76 KiB) Viewed 6154 times

OR

1.) Go to export
2.) Enter the folder directly into "Repository path"
Folders:
okm:categories
okm:mail
okm:personal
okm:root
okm:templates
okm:thesaurus
okm:trash

Cheers,
pldemon

[dummy]

I solved my problem with your instruction. Thank you so much

[jllort]

As described pldemon the order is important. If you're using categories first importing data must be categories otherside system will not be able to restore relations between documents and categories.