Migrate to MySQL

[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

[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.

[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

[jllort]

We're actually rebuilding our documentation. Hope in 4-5 months will be available.