migration hsqldb to mysql

[vincentk222]

Hi
I have make standard installation using hsqldb on windows. For somme reason we need to migrate to mysql .
I have export all the repository using the export tool from OKM in admin Tab.
The I have make my new installation with mysql (I have check the table they are in UTF-8).
Then I have import all the data using the import tool from OKM in admin Tab.

Now I have some problème with charater like "é" which are not converted correctly.

Is there any procedure to fix that?

Vincent

[jllort]

Check one problematic file:
1- is the file name correct in your file system ?
2- open "filename.okm" file with UT8-editor like geany. Are values into correctly written ?

From which version have you exported ? I suppose to latest 6.3.1 no ?

[vincentk222]

OKM file with index are ok
Migration is from 6.2.4 HSQL to 6.2.4 Mysql

[jllort]

can you upload here some zip file to reproduce the error ( file.doc + file.doc.okm ? ) only a single file will be great

[vincentk222]

ok, I was not abble to reproduce the problem, and I can not send the orginal data.
We have made a work around to import original data with xml.
thanks for help

[jllort]

If you can create a document in old system, export and then get the problem again, tell us and we'll try to identify the reason of the error.

[vincentk222]

Hi,
it is not possible because we have deleted the old system. However, we suspect that is the default language used at OpenKm logon.
We logged with english, export data.
then install new sytem
We logged in french and inport data.

[jllort]

I do not believe it will be the reason, Anyway is easy to check, log with english and then check the import process again.