Page 1 of 1

Swichover to Mysql or Postgres

PostPosted:Wed Feb 05, 2014 6:27 am
by NickC
Hi
I have set up and populated openkm for sometime now. The installation contains some 7 gb of data but wish to switch the database to a more resilient one such as mysql or postgres to continue my testing. Your documentation noted that the change to another database should be done at installation time. Is there any way to do this at this late stage or do I have to delete everything and start a new installation? Surely doing it again is to be avoided.

Re: Swichover to Mysql or Postgres

PostPosted:Wed Feb 05, 2014 11:16 am
by jllort
Database change means export and import files again ( there's no other way for doing it ). MySQL or PostgreSQL are both good elections.

For this kind of migration can reuse a lot of information from here http://wiki.openkm.com/index.php/Migrat ... .11_to_6.2 ( for example the sql queries to get sql inserts user creation etc... )