How to Export a Database using phpMyAdmin

When you export a database, you are creating a backup file for it.

This backup file, which is typically a.sql (text) file, can be used to copy and import the database onto another server.

Step 1: Open phpMyAdmin.

Log in to your cPanel and select the phpMyAdmin icon from the Databases section.

Step 2: In the left menu, select the database you’re working with.

Step 3. Select Export from the tabs at the top of the screen.

Step4: The Quick method is the export option for which we are providing instructions.

Quick is selected by clicking the radial button.

Click Custom if you want more complete control.

In order to use these options, you must be familiar with exporting MySQL databases.

If you are not, please seek the advice of an experienced database administrator or developer.

step5. Following that, you must select the export file format.
It should be set to SQL by default, so nothing needs to be changed.

Step 6: To begin the export, click the Go button.

How to Create a MySQL Database in cPanel

 The following steps are involved in the process of creating a new database:

Making a database

Adding a Database User

Allowing your database user to work with your database

Fortunately, cPanel includes a MySQL Database Wizard that guides you through each of these steps

Creating a Database in cPanel Using the MySQL Database Wizar

Access your cPanel.

Under the Databases section, select the MySQL Database Wizard.

Following New Database

Give your database a name and then click Next Step.


Enter a username next to Username.

Enter a password next to Password and repeat it for

Fill in all of the blanks.

On the following page, you will grant the user database access.

Congratulations!

You now understand how to successfully create a database.

Working with Databases

Database creation, import, and export

In cPanel, how do I create and attach a database user?

This article will walk you through the process of creating and attaching a database user in cPanel.

Creating the database user

Navigate to your cPanel dashboard.

Locate the Databases icon on your main cPanel page and select the MySQL Databases option.

Scroll down until you see the MySQL Users Add New User section once you’ve entered the database area.
You will see the form to create your new user from here.
It is important to note that the database name will always begin with your cpanel username.
To create the new database username, add the second portion.

Fill out the Password and Password (Again) fields with your desired password.

To finish creating database users, click the Create User button.

How to Edit the .htaccess File

This post will show you how to update an existing.htaccess file in cPanel.
The configuration file for an Apache web server, known as a “.htaccess” file, includes instructions for the various folders of a website.

The acronym “htaccess” refers to the HTTP access protocol, which is used to transfer websites.
Let us follow the steps to edit the .htaccess file:

1. Log in to Cpanel

2. Select the “Files” option and click on the “File Manager” sub-option.

3. You can find the “.htaccess” file in the “public_html” folder. Select the “.htaccess” file.

4. Right-click on the file and select the “Edit” button.

5. You will enter the new page.
6. Here you can make necessary changes.

7. Then click on the “Save Changes” button on the top right side of the screen.

You may now change the.htaccess file in cPanel.We have a skilled team that takes great care of our consumers.As a result, you can simply contact them anytime you want assistance because they are available 24 hours a day, seven days a week.

To check our latest web hosting plans, please visit our website and initiate a live chat.

Restart cPanel using the Command line.

If you altered a service’s settings, for example, or if the service is experiencing problems, you may want to restart it. And this can be done with a single command from the WHM Server’s root user.

Restarting cPanel will restart all services on the cPanel server, including, MySQL, server, tail watch, and so on.

Follow the steps:

  1. Log in to the WHM Server’s root directory.
  2. To restart the cPanel service, type the following command:

service cpanel restart

The cPanel service will be restarted with the command above.

Important Note: Restarting cPanel will restart all services on the cPanel server, including, MySQL, server, tail watch, and so on.

This way you can restart the cPanel using SSH (Command line).
How to use the Command line to Restart the cPanel

How do Email Filters work

Email filters are useful to create rules to block unwanted emails, based on certain rules you choose. You can specify some rules like a message containing a specific word should be deleted or passed to a specific program. These filters work subsequently, for example, if mail passes through a filter, but can be blocked by another filter. You can specify multiple rules in one filter too.

Through this user-level filter, you can create email filters, which will apply to emails that will be received by that email address.

Create a User Level Filter

To create a user-level email filter, follow these steps −

  1. Open user-level email filters by clicking on the Email Filter found under the Email section of cPanel.

2. In Email Filters, you will see the list of emails associated with your domain. Click on the Manage Filter link corresponding to the email on which you want to create a filter.

3. Click on Create New Filter button to go to a new filter creation interface.

4. Provide a name for your filter.

5. Select rules for filtering your message. To add additional rules, click on Add (+) button on the right side, to remove rules click Subtract (–). Also, choose the ‘and’ or ‘or’ rule.

6. Select an Action for a message those passes to the rules of the filter. To add additional rules, click on Add (+) button on the right side, to remove rules click Subtract (–).

7. Click on Create button to create a filter.

How to access Webmail through Cpanel

Webmail is a web-based email client, which allows you to access your emails through any browser or any computer. This is very helpful when you do not have access to the computer on which your email is set up, you can log in to your account from anywhere to read your emails and to quickly respond.

Follow these steps to log in to your webmail client −

1. log in to your cPanel and click on Email Accounts found under the Email section.

2. Click on Check Email for accessing the webmail account.

4. Choose any Webmail application. You can also set a default Webmail application, so whenever you log into your webmail, your default webmail application will automatically load.

5. You can also access other mail services we provide like Horde.

Access webmail directly

To access webmail directly without logging into cPanel, you can use the following steps −

Step 1 − Navigate to https://your–domain.com:2096 or https://webmail.your–domain.com through your browser’s address bar.

Step 2 − The webmail login screen will appear, Enter your Email and Password of your email account.

How does FTP works in cPanel

File Transfer Protocol (FTP) allows you to manage your files with third-party applications like FileZilla, CoreFTP, etc. Using an FTP file manager to upload files is a great practice when the number of files or size of the files is large. FTP accounts configure users who can upload, download or modify your files through FTP. Each FTP user has his own username and home directory, only that certain directory the user will have access to.

To create an FTP account, please follow these steps −

  1. Open the FTP accounts feature by clicking FTP accounts found under Files Section.

Add FTP Accounts
2. Enter a login name for your new user, it will be the user’s username, also provide a strong password for this user.

Step 3 − Enter Directory for your new user, you may also leave it with a pre-filled directory name according to your user.

Step 4 − Provide FTP storage quota, you may provide unlimited quota or use some value in Megabytes.

Step 5 − Click on Create FTP Account and Your FTP account will be created.

What is Softaculous?

Softaculous Auto Installer

Softaculous is the leading Auto Installer having 380 great scripts, 1115 PHP Classes and we are still adding more. Softaculous is widely used in the Web Hosting industry and it has helped millions of users install applications by the click of a button. Softaculous Auto Installer easily integrates into leading Control Panels like cPanel, Plesk, DirectAdmin, InterWorx, H-Sphere.



Softaculous allows you to add a range of online apps to your website, such as forums, blogs, eCommerce shopping carts, picture galleries, and much more.
Softaculous was founded in 2009 and has since grown in popularity in the web hosting market owing to the numerous benefits it provides to consumers.

Softaculous installation scripts provide a diverse set of web apps.
Blogging, ad management, CRM, content management, customer care, eCommerce, ERP, and other categories are available through Softaculous.
There are currently 380 Softaculous scripts available.

After inputting all of the required information, the installation procedure for any programme via Softaculous is meant to be as simple as one click.
Applications may be downloaded via the specific application’s install tab

Softaculous automatically organizes the database configuration, web server files, user permissions and installation.

First let’s have a look at the main highlights of Softaculous that determine its popularity:

  • Easy to use
  • One click installation of applications
  • Over 380 scripts
  • Scripts are updated regularly
  • User friendly interface that is ideal for beginners
  • All installation settings can be modified through user interface
  • Backup and restore tool
  • Demo scripts available before you install them on the server
  • Great technical  support and community forums

Getting Started!

Softaculous allows you to install any program with a single click!’

Does this imply that installing Softaculous is likewise simple?

No, not really, but Softaculous has worked hard to make installation as simple as possible.

Basic understanding of Linux system administration will be useful if you install Softaculous on your own.
Softaculous installation on the Linux platform may be as easy as three one-line commands.

On the other hand, if Softaculous is provided by your web hosting company, you don’t have to worry about installation.


How To Use Softaculous For Installing Applications?

To begin installing web apps with Softaculous, first log in to Softaculous via cPanel.
On the left side of the screen, you will see a selection of programmes; choose one of them.

Softaculous has a policy of upgrading the programmes to match the most recent stable versions.
Softaculous’ user settings allow the user to modify the language, the screen display of side menus, and the default time zone.

Scripts written in the standard PHP language are connected with many applications.
Softaculous also provides Pearl, JavaScript, and PHP class capability for those that are technically savvy.

Let Others Know What You Think!

Softaculous does more than only install web applications:

It gives ‘See the Demo’ displays of various apps so that consumers may get an idea of how the online applications appear.

It allows users to evaluate and review programmes, as well as contribute more information to others to help them choose the best application.

If you want to deal with a variety of online apps, you must have Softaculous since it makes life easier!
The one-click installation option saves a significant amount of time and work spent on integrating the application into your website.

How to Setup Backups in cPanel

This post will attempt to set up backups in cPanel. We all are aware that the system could go down at any time due to technical concerns. As a result, we must be prepared for such situations. We should back up our data regularly. Backups can be made and then downloaded to your local PCs.Let us see how to do it:

1. Log in to the cPanel account.
2. Click on the “Download a Full Website Backup” option.

3. After you download, the backup will be automatically saved into your account’s home directory.
4. You can also change the destination of the files to be saved.
5. Enter the Email address and click on “Generate Backup”.

6. You will see a message “Full Backup in Progress…”.

7. Click on the backup name as shown in the image given below, to download it.