The control panel cPanel is certainly among the most popular systems for management via a dedicated server web interface. It’s simple and powerful at the same time offering a high degree of stability and security. The latest available version is 11.25. cPanel offers the ability to easily administer all the services associated with the domain; with a simple click on the icon of the panel you can add e-mail, direct access to files, activate a MySQL database, backup files, install a shopping cart and more.

The use of the panel is simplified and well designed with a user friendly interface.

Access to the different configuration options is simplified by a convenient categorization.

cPanel and DNS configuration

The DNS is a network component that translates domain names for users to more easily interpretable numeric ip from a computer and vice versa.

Addon Domains , lets you add new domains , while a DNS zone is a contiguous portion of the DNS domain name space in which a DNS server has authority. A zone is therefore a portion of a namespace . It is not a domain. A DNS server can be authoritative for multiple DNS zones. A DNS zone file is a file that contains the DNS records that describe the hosts on the network. There are different types of DNS records, cPanel allows you to add and delete records of type A and CNAME records :

• Record : record address, returns a 32-bit IPv4 address, normally used to connect a host name to its IP address;
• CNAME : canonical name record, a DNS name allows you to connect to another. The resolution will continue under the new name specified by CNAME records

An example of domain configuration with cPanel

To add a domain (eg domain.com ), click on the Addon Domains from the main panel and fill in the required fields , some will be filled automatically by cPanel:

Click Add Domain: If the operation is successful the new domain will be listed at the bottom, as shown in the figure.

Add and delete records and CNAME

Link on the Simple DNS Zone Editor, you can access the control panel to configure the DNS zone.

Importantly, cPanel will help you to configure the DNS records so that visitors of your website will be able to access the website and its services (FTP, e-mail, etc..)  You should add a new record only when you add a service that is not provided by cPanel or from your web host.

The software Softaculous is now a great alternative to FANTASTICO. This aims to add value to the cPanel control panel through the facility to install new scripts propulsion (joomla, wordpress, magento, etc.).

After being logged in as root in terminal, run the following commands:

cd / usr / local / cpanel / whostmgr / docroot / cgi

wget-N http://www.softaculous.com/ins/addon_softaculous.php

chmod 755 addon_softaculous.php

Now, just access the WHM and complete the installation.

If using RVSkin themes you must run the following command to which the Softaculous appear in cPanel:

/ Root / rvadmin / autoupdatewhmaddon.pl

Databases are always being the main concern of the servers. Along with backups one can be rest assured that their database is secure and can be utilized as and when required. Websites today rely a great deal on databases to store vital data, which may include member information as well as website content.

Backing up MySQL database involves a strategic integration of resources. One can give preference to the automated backups as well. While automated backups are important, sometimes you just want to take a quick snapshot before making a change to your data. Dedicated web hosting solutions gives you full control over them. This helps you in making any crucial changes on your own and also gives you the liberty of installing or updating any softwares. You can do whatever you want with the box, implement services and of course a full root access with the machine.

People with the past experience in the web technologies knows that backups are a good practice and better too many than none. This practice of backing up the database of a website is fairly proves to be fruitful for a website and its content. If something happens (for instance, if the database gets corrupted), you’ll get to experience will be worst, but with the backups you can anytime recover it without any hassles. MySQL databases are the most popular open source databases that are used to power most of the websites today. This is why, it is very important to understand some basic working and administration of MySQL databases to comfortably manage your website.

We will have a quick peak into as how to make a backup and also restore a MySQL database with the following procedure:

The first and foremost step is to “Login into cPanel” you can follow the procedure like : type the URL http://<yourwebsite address>/cPanel in the Address bar of your Web browser and then press Enter. When prompted, enter your user id and password.

Then on the second step “ Login to PHPMyAdmin”: Sign into it as a valid root user or an administrator for your database. Then select the database which you want to backup. The menu for the database will come on the left side margin.

Then the another step is to Click on the Export tab once web page screening the selected database. Click on the saves as file option, which will save the file on your PC >> You can select database format either CSV, CSV for Excel or in .sql format.

Then with the ADD DROP TABLE option you can add table functionality. Generally the table exists in the database backup.

After that to import.sql file >> Click on the Import option (right side on the export tab).

Finally, Click on the Browse button to select .sql file from your local PC.

From the drop down menu, you can choose the character set of the file. If you are not firm with the character set then leave it default. Then the last step would be in order to proceed, click on the Go button (bottom of the right).