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

Migration from one server to another (MSSQL)

Author: Edward Hardin Reference Number: AA-00735 Views: 9104 Last Updated: 11/12/2012 04:43 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. Backup the database on the old server and import the dump file to the new server. Use MSSQL database management tools for that. They provide the best performance and convenience.
  4. Copy the KMP files from the old server to the new one.
  5. 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.
  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 would be different.

  7. If the domain name of the new server will differ from the original, you would need to execute one SQL query to update links to embedded images:
    UPDATE faq_articles SET answer = cast(replace(cast(answer as nvarchar(max)), 'http://www.oldserver.com/kb/admin/media_store/2/', 'http://www.newserver.com/kb/admin/media_store/2/') as ntext) 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

  8. Login to KMP on the new server and check thoroughly if everything is working correctly.
  9. 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).
  10. Setup Cron Job.

Custom Fields
Database type:MySQL