Backup and Restore on Windows

Contents  Previous  Next

Upgrading KnowledgeTree > Backing up and Restoring > Backup and Restore on Windows


This procedure backs up your database to a file (e.g. dump.sql) and restores your database from backup file (Windows users).

 

Perform the following steps:

1.Click Start - Run; then, type cmd in the Run dialog box.

 

2.To BACKUP ...
2.1.Enter the path to the KnowledgeTree install directory, e.g: KnowledgeTree_Directory\mysql\bin

 

2.2.Enter the following command: mysqldump -u dmsadmin -p dms > dump.sql

 

2.3.When prompted for a password, enter the MySQL password you set up during your KnowledgeTree installation.

 

2.4.The database is saved to dump.sql. - by default this is in the ...\mysql\bin directory. Keep this file in a safe place.

 

3.To RESTORE ...
3.1.Navigate to KnowledgeTree_Directory\mysql\bin

 

3.2.Enter the following command: mysql.exe -u dmsadmin -p dms < dump.sql

 

3.3.When prompted for a password, enter the MySQL password you provided during your KnowledgeTree installation.

 

 


© 2008, 2009 KnowledgeTree Inc. - Document Management Software
This work is licensed under a Creative Commons Attribution 3.0 License.
addThis