MachPanel Knowledgebase

INFO:SharedHosting - Database Only Hosting

Mudesira Munir


This articles describes in detail about the Integration of Database Only Hosting (Shared/Web Hosting) and Database Only Subscriptions and Management.

Applies To

This article applies to MachPanel v6 and above.

  1. MachPanel Control Server has been installed, if not then follow below KB article:
  2. MachPanel Remote Server has been installed, if not then follow below KB article:
STEP-1: Integrating Database Service with MachPanel Web Hosting:
  • Open MachPanel Control Panel Website (You can do it by opening MachPanel Control Server Configuration Studio and then navigating to Configure > Control Panel Website, and then clicking on the URL in it). Log in with the provider credentials.
  • Add Web Hosting server Group if not added already. Navigate to Home > Service Director > Web Hosting > Server group and then click on Add Server Group. For more details click Add Web Hosting Server Group
  • Now Click on Server Group Name, new tab "Web Hosting Servers" will open and you will also see Services in options column.


  • Click Services in the options menu against the desired server then click on Add Service button.


  • To add Database Service to your Hostmatic/Web server, select Database from the drop down list.


  •  Now, select Provider for the Database service and provide necessary details such as SQL Database Settings, Database Backup, Account Limits, DNS Record. Click Save when done See the snapshots below:


  • Hit Test Service for each service and if you get Successful message in Green then integration of that service is successful.
STEP-2: Creating Database Only Product/Package:
  • To add a Database Only - Shared Hosting Product navigate to path: Home >> Service Plans >>Hosting Products. Select Customer Product Listing tab for Customer plan.
  • Click Add New Product button as shown below:

  • Now provide basic details such as Server Group, Product name and select Package Type Database Only.

  • Under Resources tab, Provide Resources for the Database Hosting.Provide Following fields:
  1. Maximum MS-SQL databases
  2. Maximum MS-SQL database size per database (MB)
  3. Maximum MS-SQL database users
  4. Maximum MY-SQL databases
  5. Maximum MY-SQL database size per dataBase (MB)
  6. Maximum MY-SQL database users
  7. Maximum ODBC DSN


  • Select Payment Cycles and Payment Groups and click Next.
  • Add Price Group and click Next.
  • Associate Add-on (if any) and then Finish to create the Package.
STEP-3: Provisioning and Selling of Database Only - Shared Hosting Plan:
  • In this step you have to sell and provision the Database Only Plan to the customer. Select Shared Hosting under "Service".


  • Select the Database Only Plan under "Package".

STEP-4: Management of Database Only Subscriptions:
  • Navigate to following path to manage Database Only Subscription:  Home >> Service Director >> Web Hosting >> Hosting Accounts
  • Select Database Only Subscription tab as shown below:

  • Now you can add & manage Databases and Database Users under their respective tabs as shown below:

  • By clicking on Manage button you will see
  • Under Manage Database section, there are two operations Backup Database and Restore Database
  • By clicking Backup Database, backup of database can be saved \Root\Backups
  • To Restore from a backup, you need to click on Restore Database, on clicking you will see a section as shown below

    Locate file by clicking Browse button, select file by clicking the Name of Database backup file

    Click Done, you will see

    Click Restore button.
  • Under Database Users Tab user related operation, setting password, Set as Owner or Removing a user can be performed

Type: INFO
Level: Intermediate
Last Modified: 2 Years Ago
Last Modified By: Khurram.hameed
Article not rated yet.
Article has been viewed 1.8K times.
Also In This Category