Migrating Enterprise Version To New Server

Procedure for migrating HostBill enterprise version onto new server / reinstalling enterprise version without data loss.

Before you start:

Make sure you've updated to the latest HostBill version on old location first. If you're unable to update (ie: you need to migrate because you use unsupported PHP version), please use this procedure below and step 11.

1. Old Server: Login to your HostBill server as root. Proceed to HostBill includes directory:

cd /home/hostbill/public_html/includes/

2. Old Server: Check database name to create dump of:

cat config.php | grep db_name

Sample return: >$db_name = '1408513157';

From same file, please copy value of $ccEncryptionHash variable.

3. Old Server: Copy database name, create dump

mysqldump --routines --hex-blob 1408513157 -r /root/hbdump.sql

4. Old Server: If you have some customisations done already or modules uploaded, backup public_html folder

  cd /home/hostbill/public_html/
  cp includes/config.php includes/config.php.backup
  tar -zcvf /root/hostbill.publichtml.tgz --exclude='config.php' .

Note: Consider creating backups of /home/hostbill/attachments and /home/hostbill/downloads folders, if you use support plugin and downloads section in clientarea already

5. Old Server: Store /root/hbdump.sql and /root/hostbill.publichtml.tgz in secure place or upload it to your new HostBill install server

6. New Server: install HostBill enterprise using installation command you have received after purchasing HostBill.

Note

Make sure to start with clean OS install!

7.New Server: On fresh install get new database name:

  cd /home/hostbill/public_html
  cat includes/config.php | grep db_name

Sample return: >$db_name = '1408513158';

Edit includes/config.php file, update $ccEncryptionHash variable to value from old server.

8. New Server: Apply sql backup to new database

mysql 1408513158 < /root/hbdump.sql

9. New Server: Apply public_html backup onto fresh install

tar -zxvf /root/hostbill.publichtml.tgz -C /home/hostbill/public_html/

10. New Server: From /home/hostbill/public_html/includes/config.php.backup copy value of $ccEncryptionHash and paste into config.php file:

   cat /home/hostbill/public_html/includes/config.php.backup | grep ccEncryptionHash >> /home/hostbill/public_html/includes/config.php

11. Optional, New Server: Use this step only if you were unable to update your HostBill old od server to latest version

Download latest HostBill version from HostBill licensing portal
Unzip it somewhere locally on your computer, take entire /install folder and upload it to your new server, /home/hostbill/public_html/ directory
Visit yournewhostbill.url/install in your browser, and select "Update" option to update database to the latest version (replace yournewhostbill.url with actual installation url of your HostBill copy)
After successfull update, remove /install folder

Final steps:

Verify ownership of files in /home/hostbill/public_html, make sure those match owner of /home/hostbill target dir (usually hostbill or hb_XXXXXXX)
After re-install directory of your HostBill license will change, which will cause license issue. Update license directory in https://clients.hostbillapp.com/ after fresh install