How to migrate/move the PHPKB database to new server?

To migrate/move PHPKB database to a new server, first of all, you would need to know the database type i.e. whether you have been using PHPKB Edition that works with MySQL / MariaDB or Microsoft SQL Server.

Note: In case you have no idea which one you have been using, you can simply log in to Administrator Control Panel as Superuser and go to Tools > Manage Settings > General tab > Product Details section and find (MySQL / Microsoft SQL Server) information there.

Step-by-Step Instructions for Microsoft SQL Server:

  1. Generate the database backup of your existing PHPKB through Microsoft SQL Server Management Studio (SSMS).
  2. Move the backed up database copy to the new server and restore it using SSMS.
  3. Log in to Administrator Control Panel as Superuser.
  4. Go to Tools > Manage Settings > General tab and scroll down to Database Settings section.
  5. Update the new database settings i.e. DSN, Username and Password details.
  6. At last, double-check the database settings and then save your changes. If everything goes right then you should be logged out from PHPKB automatically and that is completely normal because we have updated the settings.

Step-by-Step Instructions for MySQL / MariaDB:

  1. Generate the database backup of your existing PHPKB through either MySQL Workbench / phpMyAdmin / any other tool that is available.
  2. Move the backed up database copy to the new server and restore it using either MySQL Workbench / phpMyAdmin / etc.
  3. Log in to Administrator Control Panel as Superuser.
  4. Go to Tools > Manage Settings > General tab and scroll down to Database Settings section.
  5. Update the new database settings i.e. Hostname, Username, Password and Database Name.
  6. At last, double-check the database settings and then save your changes. If everything goes right then you should be logged out from PHPKB automatically and that is completely normal because we have updated the settings.

That’s all!


Article ID: 262
Created: January 20, 2021
Last Updated: January 29, 2021
Author: Palwinder Singh [singh@phpkb.com]

Online URL: https://www.phpkb.com/kb/article/how-to-migrate-move-the-phpkb-database-to-new-server-262.html