• Swichover to Mysql or Postgres

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #27732  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.
 #27741  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... )

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.