Page 1 of 1

Migrate to MySQL

PostPosted:Fri Jan 23, 2015 2:23 pm
by MKochS
Good afternoon list,

I have an installation with a database file of almost 10GB now and need to move to MySQL asap, as the whole system is going painfully slow. The new system is up and running, with a MySQL database configured and ready.

My problem is: I cannot move the repository without losing the categories.

I have followed these instructions:
http://wiki.openkm.com/index.php/MySQL-OpenKM_6.2

I exported the categories and imported them into the new system - ok. The categories are there.

Next I exported the root taxonomy (history and metadata included) an reimported it into the new system. The files are there, and so are the keywords. But the categories remain empty.

What am I missing? Maybe there is another procedure available?

TIA
Matthias

Re: Migrate to MySQL

PostPosted:Sat Jan 24, 2015 10:54 am
by jllort
You must export everything with UUID. When you import again, first of all must import categories ( also with uuid option checked ) and then the others nodes ( okm:root etcc.... ) always with uuid option checked.

Re: Migrate to MySQL

PostPosted:Wed Jan 28, 2015 9:31 pm
by MKochS
Checking "restore UUIDs" did the trick. Thank you very much.

I believe it's not mentioned in the community docu. Adding it might be a good idea.

Kind regards
MKS

Re: Migrate to MySQL

PostPosted:Fri Jan 30, 2015 10:54 am
by jllort
We're actually rebuilding our documentation. Hope in 4-5 months will be available.