Backup and Restore on Linux

Contents Previous Next

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

This procedure saves your database to a file (e.g. dump.sql) and restores your database from the file where it was backed up (Linux users).

Perform the following steps:

1.	Open a terminal.

2.	Enter KnowledgeTree_Directory\mysql\bin

3.	Do you want to ...

•	Backup your database? Go to step 4.

•	Restore your database? Type ./mysqldump --socket= KnowledgeTree_Directory/mysql/tmp/mysql.sock -u dmsadmin -p dms < dump.sql

4.	To BACKUP, do the following:

4.1.	Enter the following command:

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

Note: This command saves the database to dump.sql

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

4.3.	The database is saved to dump.sql. Ensure that you keep this file in a safe place.

5.	To RESTORE, do the following:

5.1.	Enter the following command:

./mysql --socket= KnowledgeTree_Directory/mysql/tmp/mysql.sock -u dmsadmin -p dms < dump.sql

5.2.	When prompted for a password, enter the MySQL password you provided when installing KnowledgeTree.