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.
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:
- Delete all files of current KMP instance.
- Copy files through from the back-up.
Restoring The Database
There are two required steps:
- Drop all tables from the KMP database (i.e. delete all tables to empty the database).
- 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.