bluehost mysql database – frequently asked questions

Hosting your domains on Blue host platform comes with innovative web-hosting features at no extra cost. One of such innovative hosting solutions is Blue Host MySQL Database. Right now, you can jump at the Blue host coupon code $3.95 per month to enjoy extensive web-hosting solutions,
and at the same time save as much as 75% on all your web-hosting purchase. Blue host is one of the top leaders in the web-hosting industry, with reputation of offering quality web-hosting affordably. This article covers some frequently asked questions about MySQL Database feature on Blue-host platform.

What is Blue-Host MySQL Database?

MySQL is a web-based solution that aids in the management of huge amounts of information over the internet. No matter how large, managing on-web information comes easy with a database. A good number of the internet-based applications require a database to run. Examples of such applications include the following;

•    Bulletin boards
•    Content management systems
•    Online-based retail stores or shops.

MySQL Database is a complete FREE tool when you host your account on Blue-host platform.

How Can I Create MySQL Database?

Here are the steps involved in creating MySQL Database;
•    Access your control panel
•    Click MySQL button found right under the “Databases” section
•    In the “New Database” text field, write the name you prefer for the new database
•    Hit the “Create Database” button to complete the process.
When you click on “Go Back”, you will see the new database created appear in the “Current Database” table. 

How Do I Delete a MySQL Database?

If at any time you chose to delete MySQL database that you created, follow these simple steps to accomplish the task;
•    Navigate your cursor to the “Current Database” section
•    Find the “Delete Database” icon placed by the side of the database you want to delete
•    Click on the “Delete” icon to remove the database

How Do I Copy a Database?

The steps involved in copying a database require exporting the original database first, then importing it onto the new one.

So, here are steps to export the original database;
•    Navigate to phpMyAdmin
•    On the left sidebar, click on the existing database
•    Locate “Export” link at the top and click on it
•    Check the “Save on server in the directory” button
•    Click Go

The above steps will save an SQL file on your account in a temporal folder.
Steps to import onto a new database;

•    Log in to your Cpanel and create a new database
•    Navigate to phpMyAdmin
•    At the top left, click on  “New Database”
•    Locate ‘Import’ in phpMyAdmin’s main area and click on it
•    Locate the “Select from the web server upload directory/home/USERNAMe/tmp/:” radio button and click to check it
•    Click on the imported database from the drop-down men
•    Click Go

Take note: After 30 seconds, phpMyAdmin will time out. If this happens, you should upload the database backup file into your account and use the details to create a Ticket, so that Bluehost technical crew will help you accomplish the “Import”.

For increased security, the best bet is to upload your database to “/home/USERNAME” section on your Bluehost account. Use your Bluehost account username to replace USERNAME.

How Can I Rename a Database?

In order to rename your BlueHost MySQL database, you will repeat the steps abovek; then import the database to an empty, new database with your preferred name.

How Can I Manage Database with Applications?

When it comes to managing your BlueHost MySQL Database, there are tons of applications that can be installed onto your PC for this purpose. Some of the applications are provided by third-parties, some will cost nothing while some will come with  fees. The type of database a user is connected to will determine what database management application to choose. MySQL database is a feature that accompanies all Bluehost webhosting plans.

If you wish not to use a desktop application for MySQL database, you can manage your database with the phpMyAdmin through your cPanel, accessible through a web browser.

Our list of recommended applications for managing MySQL contains the following;

•    EMS SQL Management Studio – not free
•    EMS SQL Manager – could be free or fee-attached
•    MySQL Workbench (Oracle product) – Free or fee-attached
•    Navicat – not free

Note: You can only use one of these recommended applications at a time.

Blue-host offers world-class web-hosting features affordable. You can save even more on quality webhosting services by taking advantage of Blue-host discount coupon $3.95 per month to purchase webhosting on this platform. The right time to use this discount offer and save 75% on web-hosting is now since it is a limited-time offer!

No comments: