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

Migration from one server to another (MySQL)

Author: Edward Hardin Reference Number: AA-00586 Views: 4809 Last Updated: 07/24/2017 12:03 PM 0 Rating/ Voters

To move KMP from one server to another, please follow these steps:

  1. Make sure that the new server meets the software requirements. If you're moving to an IIS server, you can use our guides for PHP installation.
  2. Compare the PHP settings on two servers. You would probably want to copy the following parameters and the list of enabled extensions through.
    post_max_size
    memory_limit
    upload_max_filesize
  3. Disable STRICT_TRANS_TABLES setting in MySQL configuration: STRICT_TRANS_TABLES error when I setup database
  4. Dump the database on the old server and import the 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).
    Use this command to dump the database:
    mysqldump -u db-login-on-the-old-server -p --default-character-set=utf8 kmp-database-on-the-old-server > dump.sql
    And this command to restore it on the new server:
    mysql -u db-login-on-the-new-server -p --default-character-set=utf8 kmp-database-on-the-new-server < dump.sql

    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. To upload a large database dump you would probably need BigDump tool.

  5. Copy the KMP files from the old server to the new one.
  6. Set write permissions to the KMP files on the new server as described in the "After Installation" section of the instructions in this page that match your web server platform.
  7. 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 would be different.

  8. 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://www.oldserver.com/kb/admin/media_store/2/', 'http://www.newserver.com/kb/admin/media_store/2/') WHERE `account_id`=2;

    where:
    www.oldserver.com is the old server domain name
    www.newserver.com is the new server domain name
    if you also change the folder for the knowledge base, adjust the query accordingly

  9. Login to KMP on the new server and check thoroughly if everything is working correctly.

    Warning!

    Pay attention to the encoding, if you're using unicode characters, information can be damaged due to incorrect settings on one of the MySQL servers. Do not delete KMP instance on the old server for at least a week, just in case.

  10. KMP should be up and running on this step. Now you should check the Post Installation Tasks and Checklist to setup recommended settings and install optional components (such as attachment indexation plugins, PDF export plugin, etc).
  11. Setup Cron Job.

Custom Fields
Database type:MySQL