Online Chat
 Call Us: 
1-877-744-1221
Browse Submit a Ticket
 
Advanced Search
Tools
Rss Categories

How to backup your knowledge base? (MySQL)

Author: Edward Hardin Reference Number: AA-00638 Views: 14013 Last Updated: 08/15/2013 11:26 AM 39 Rating/ 7 Voters

You may want to backup your knowledge base from time to time or on a regular basis. Also you simply must backup before updating KMP to a new version, because otherwise you could lose all your data if something goes wrong.

We recommend to make backups on the file and database level rather than backing up from KMP user interface.

First of all, remember that KMP stores some data (most of it) in its database and some data (attachments and images) as files. This means that, to make a full backup which you could use to recover your knowledge base at any moment, you need to backup all KMP files and KMP database.

Snapshots

If your server support snapshots, that would be a great way to backup your knowledge base. Just make sure that snapshot includes files and database backup.

Backup

Backing Up The Files

There is nothing sophisticated about backing up KMP files - simply copy ALL KMP files to a secure location.

Backing Up The Database

The best way (i.e. easiest, fastest, and error-free) to do this is to use MySQL command "mysqldump". These command is available if you have SSH access to the MySQL server (if it is Linux server) or if you have RDP access or direct access (if it is Windows). This article explains how to backup and restore database via command line.

If you do not have access to the command line on the server, you can dump the database using phpMyAdmin or any other tool that is usually provided by ISP for database management. 

Restore

Restoring The Files

There are two required steps:

  1. Delete all files of current KMP instance.
  2. Copy files through from the back-up.

Restoring The Database

There are two required steps:

  1. Drop all tables from the KMP database (i.e. delete all tables to empty the database).
  2. Upload the database from backup.

The best way (i.e. easiest, fastest, and error-free) to upload the database is to use MySQL command "mysql". These command is available if you have SSH access to the MySQL server (if it is Linux) or if you have RDP access or direct access (if it is Windows). This article explains how to backup and restore database via command line.

If you do not have access to the command line on the server, you can restore the database using phpMyAdmin or any other tool that is usually provided by ISP for database management.To restore a large database dump you would probably need the BigDump tool. It is the only known PHP script that is capable of uploading large (more than 10Mb) database dumps.

Custom Fields
Database type:MySQL