Migrating KnowledgeTree from Linux to Windows

From KnowledgeTree Document Management Made Simple

Support Home » Guidelines » Guidelines - KnowledgeTree Server

Steps to perform

The following steps should assist in migrating your existing KnowledgeTree instance from a Windows environment to Linux.

Ensure that you migrate same versions of KnowledgeTree only (eg. 3.6.1 windows to 3.6.1 Linux).

1. Perform a complete backup of your existing KnowledgeTree install, including the database:
http://wiki.knowledgetree.com/Backing_up_and_restoring_KnowledgeTree

2. Save your existing database to a file (e.g. dump.sql):

a. Open a terminal session

b. Browse to the following location: <KnowledgeTree_Directory>\mysql\bin

c. Enter in the following command:

./mysqldump --socket=../tmp/mysql.sock -u dmsadmin -p dms > dump.sql

d. You will now be prompted for a password, enter the MySQL password you set during your KnowledgeTree installation.

e. This will save the database to "dump.sql", make sure you keep this file in a safe place

3. Working from your Windows environment from now on, perform a full, fresh install of KnowledgeTree

4. Copy your documents from the old Linux location to your new Windows environment

5. Drop the new database that was created during this install:

a. Open a Command Prompt (cmd)

b. Browse to the following location: <KnowledgeTree_Directory>/mysql/bin

c. Enter in the following command:

mysqladmin -u dmsadmin -p drop dms

6. Recreate the database by running the following SQL command:

mysqladmin -u dmsadmin -p create dms

7. Copy your previous database (dump.sql) to the following location:

<KnowledgeTree_Directory>/mysql/bin

8. Restore your previous database by running this command:

mysql.exe -u dmsadmin -p dms < dump.sql

You will now be prompted for a password, enter the MySQL password you set during your KnowledgeTree installation.

9. Run the upgrade wizard.

http://locallost:port/setup/upgrade.php

10. You will now need to update paths from previous Linux ones, to Windows paths. Set the paths by running the following SQL commands (replace <KnowledgeTree_Directory> with your actual path):
See steps for starting MySQL

a. update config_settings set value = "<KnowledgeTree_Directory>\documents" where item = "documentRoot";

b. update config_settings set value = "<KnowledgeTree_Directory>\var" where item = "vardirectory";

c. update config_settings set value = "<KnowledgeTree_Directory>\var\log" where item = "logDirectory";

11. Clear your plugin registry by running these SQL commands:
See steps for starting MySQL

delete from plugin_helper;

delete from plugins;

12. Lastly, you will now need to login to the web inteface and update all other relevant paths in:
DMS Administration > System Configuration > General Settings