How to Create a MySQL Database?

To Create a MySQL Database

Create-a-MySQL-Database

MySQL is an open-source relational database management system. It is one of the best RDBMS being used for developing web-based software applications. You have access to root user, you can easy create any database using mysql. 

In this article Hostdens will give you how you can easily create a new database from your cPanel. Follow the steps and create a MySQL Database.

Step 1 : Log in your cPanel.

Step 2 : Go to MySQL Databases.

Step 3 : Navigate to the Create New Database box.

Step 4 : Enter the Database Name in the New Database text field.

Step 5 : Click on the Create Database button.

Step 6 : The database name will be preceded by the cPanel username.

Example, if your cPanel user name is user and you want to have a database named test, the actual database name will be user_test.

create_mysql_database

Then, You will get a confirmation message.

Read More

How to Back Up Your Drupal Website

database

Back Up Your Drupal Website

 Drupal Website backing up involves backing up both the site’s database and its files. Just for taking file backup doesn’t help. Always take database and files backup whenever you take Drupal Website backup.

 

Drupal_website_Backup

 

Step 1. To Back Up Your Files

1) Download all files pertaining to your Drupal website using an FTP client.

2) The illustration below shows a Drupal website installed in a sub-directory called “drupal” 

2) The FTP client FileZilla is used to download the files.

 

Step 2. To Back Up Your Database

1) Log in to your hosting account’s cPanel

2) Click on “phpMyAdmin” in the Databases section

3) Then click on Databases

4) Select your Drupal website’s database

5) Then click Export

6) In the following page, click Go

7) Save the file to your desired location.

.

.

.

 

Congratulations! You have now backed up your Drupal website.

Read More