Hosting Knowledge Base

Home » Knowledge Base » Control Panel » Advanced Tools » Database Manager

Knowledge Base

Sign up for FREE now!

Database Manager

 

In this tutorial, we’re going to show you how to use the Database Manager section in your AwardSpace.com account.

 

How to Set Up a MySQL Database?

Setting up a MySQL database can be achieved in five easy steps:

  1. Log into the Hosting Control Panel of your AwardSpace account.
  2. Go to the Database Manager page.
  3. Select the Create MySQL Database tab.
  4. Fill in the required fields.
  5. Finally, click on the Create Database button.

 
database manager 1

Congratulations! You have successfully created a new database on your MySQL server.

 

How to Access my MySQL Database?

Each server comes with phpMyAdmin preinstalled. phpMyAdmin is a powerful database management tool that allows you to perform various actions, such as:

  • executing queries
  • creating, viewing and dropping tables
  • importing and exporting data

For full documention, please check the official phpMyAdmin User Guide.

To access a MySQL database, select the database that you wish to manage and click on the phpMyAdmin 4 icon (as illustrated below).

 
database manager 2

Another way to access your database is by visiting phpMyAdmin4 directly in a web browser.

 
database manager 3
 

How to Import a Database?

Importing data into a MySQL database can be achieved by using any of the following tools:

  • phpMyAdmin
  • SSH

Below are the steps needed to import a database via phpMyAdmin:

  1. Log into phpMyAdmin using your MySQL username and password.
  2. Click the Import button.
  3.  
    database manager 4

  4. Click Browse and select the file you wish to upload to your MySQL server.
  5. Finally, press Go.

After a successful import, you will receive a message like this: Import has been successfully finished!

Note: The maximum file size for importing files via phpMyAdmin is 50MB.


In order to import data into your MySQL database via SSH, you should perform the following steps:

  1. Connect to your server using your favorite SSH client program. (Your SSH connection details can be found in the SSH Manager section of your account.)
  2. After establishing a successful SSH connection, you will need to execute the following command in your terminal (SSH program):
  3.  
    mysql -h DB_HOST -u DB_USER -p DB_PASS DB_NAME < /home/www/database.sql
     

  4. You will be prompted to enter the password for your MySQL database.
  5. Press Enter.

Note: The variables DB_HOST, DB_USER, DB_PASS and DB_NAME should be replaced with the settings of your database and database.sql with the exact path to the .sql file you will be importing data from.

You can find your database settings in the Database Manager area of your account. To view your settings, click on the Options icon and open the Information tab.

 

How to Export a Database?

You can export a MySQL database via any of the following two methods:

  • phpMyAdmin
  • SSH

To export a MySQL database via phpMyAdmin:

  1. Log into phpMyAdmin.
  2. Open the Export tab.
  3.  
    database manager 5

  4. From the Format drop-down menu select your preferred file format (SQL, CSV).
  5. Finally, click Go.


To export data via SSH, please perform the below steps:

  1. Log into your web server using your favorite SSH client program. (Your SSH connection details can be found in the SSH Manager section of your account.)
  2. After connecting to the server, you should enter the following command:
  3.  
    mysqldump -h DB_HOST -u DB_USER -p DB_PASS DB_NAME > /home/www/database.sql
     

  4. You will be prompted to enter the password for your MySQL database.
  5. Click Enter to start the export process.

Note: The variables DB_HOST, DB_USER, DB_PASS, and DB_NAME should be replaced with the actual database settings.

You can find your database settings in the Database Manager area of your account. To view your settings, click on the Options icon and open the Information tab.

 

How to Create a PostgreSQL Database?

To create a PostgreSQL database, please follow the below steps:

  1. Sign in to your AwardSpace web hosting account.
  2. Go to the Database Manager section.
  3. Open the Create PostgreSQL Database tab.
  4. Fill in the approriate fields.
  5. Finally, click on the Create Database button.

 
database manager 6

Congratulations! Your PostgreSQL database has been set up successfully and is now ready to use.

 

How Can I Access my PostgreSQL Database?

To access your PostgreSQL database, open your favorite web browser and visit the phpPgAdmin login page.

 
database manager 6

Click PostgreSQL, enter your PostgreSQL credentials and press Login.

 

How Would I Go About Upgrading my Database Quota?

If you need more disk space for your MySQL database, you would need to upgrade your account to a better hosting plan. You can review our web hosting plans and their features on our Shared Hosting page.

 

How to Connect to my Database Remotely (MySQL Workbench)?

Remote connections to our database servers are restricted due to security reasons. Therefore, MySQL softwares like MySQL Workbench and Toad cannot be used for database management. Please use the phpMyAdmin tool for MySQL (phpPgAdmin for PostgreSQL respectively), which is available in your Control Panel -> Database Manager section.

 

Am I Allowed to Use MySQL Triggers?

Regrettably, our Shared hosting platform does not support MySQL triggers. MySQL triggers can only be used on a VPS plan. We apologize for any inconvenience this may cause you.