Page 1 of 1

migration hsqldb to mysql

PostPosted:Tue Nov 17, 2015 9:40 am
by 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

Re: migration hsqldb to MySQL

PostPosted:Wed Nov 18, 2015 4:37 pm
by 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 ?

Re: migration hsqldb to MySQL

PostPosted:Wed Nov 18, 2015 5:11 pm
by vincentk222
OKM file with index are ok
Migration is from 6.2.4 HSQL to 6.2.4 Mysql

Re: migration hsqldb to MySQL

PostPosted:Thu Nov 19, 2015 4:38 pm
by jllort
can you upload here some zip file to reproduce the error ( file.doc + file.doc.okm ? ) only a single file will be great

Re: migration hsqldb to MySQL

PostPosted:Tue Nov 24, 2015 3:44 pm
by 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

Re: migration hsqldb to MySQL

PostPosted:Wed Nov 25, 2015 9:36 am
by 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.

Re: migration hsqldb to MySQL

PostPosted:Thu Dec 24, 2015 1:39 pm
by 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.

Re: migration hsqldb to MySQL

PostPosted:Fri Dec 25, 2015 11:33 am
by 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.