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

Roll out KMP from a backup (MySQL)

Author: Edward Hardin Reference Number: AA-00641 Views: 7482 Last Updated: 08/20/2014 09:51 AM 0 Rating/ Voters

Warning!

This is a special guide which applies to a case when we provide you with your knowledge base files and database with your data. Please follow these steps to roll it out on your web server.

  1. Make sure that the new server meets the software requirements.
  2. Check the recommended PHP settings. It is advised to set them before deploying KMP on the new server.
  3. Create a database on the new server. If asked for character set and collation, please select character set: utf8, and collation: utf8_general_ci.
  4. Import the database dump file to the new server. You can use your favorite database backup/restore tools for this, but the best way to do this is to use command line (it works on Windows as well as on Unix-like systems).

    And this command to restore it on the new server:
    mysql -u database-login -p --default-character-set=utf8 kmp-database < dump.sql

    If you do not have access to the command line on the server, you can upload the database using phpMyAdmin or any other tool that is usually provided by ISP for database management. To upload a large database dump you would probably need BigDump tool.

  5. Copy the KMP files to the new server.
  6. Update the /admin/config.inc.php file - adjust database host, username, password, and database name:

    'host' => '127.0.0.1',
    'username' => 'login',
    'password' => 'password',
    'dbname' => 'kmp',

    This is a sample data, your settings will be different.

  7. If the domain name of the new server will differ from the original, you would need to execute one MySQL query to update links to embedded images:
    UPDATE `faq_articles` SET `answer` = replace(`answer`, 'http://your_hosted_kb_subdomain.host4kb.com/kb/admin/media_store/2/', 'http://www.newserver.com/kb/admin/media_store/2/') WHERE `account_id`=2;

    where:
    your_hosted_kb_subdomain.host4kb.com is the domain name of your KB on our server
    www.newserver.com is the new server domain name
    if you also change the folder for the knowledge base, adjust the query accordingly

  8. Login to KMP on the new server and check thoroughly if everything is working correctly.
  9. If KMP doesn't work immediately, this usually means that some configuration of the server is not right. Try enabling error logging to find out what might be wrong. Also feel free to send it to us for checking.