1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Using Databases Overview

Using Databases Overview

 

Many websites use databases and scripting languages such as PHP, ASP, and ASP.NET to create dynamic sites and manage large amounts of information, rather than using only static HTML files. Two of the most popular databases are MySQL and MS SQL. Whether you are creating a website from scratch by coding it yourself or are installing one of the many scripts and web applications available, you probably need to interact with a database at some point, even if it is just to set it up.

Unless you are a programmer, you typically will only need to create a database and configure your script to connect to it, and you are done! But more advanced functionality is available for programmers on occasions where you need additional access.

This article will give you an overview of what things may need to be done to use a database, as well as links to the relevant articles that discuss those topics more in-depth, which also give step-by-step instructions.

Notes:
  • This article mentions cPanel and Plesk. If you purchased Shared, Reseller, VPS, or Dedicated hosting, then cPanel is available.
  • If you have Windows hosting (shared or dedicated), then you have Plesk.
  • MySQL is available on both Linux and Windows hosting, and MSSQL is only available on Windows Hosting.

Please click the links below for the different database functions and the list of articles you can refer to.


Creating a Database via phpMyAdmin

One thing that you may have to do is create a database. This is required when you are installing a script that requires a database, like a content management system (CMS), a shopping cart, forum software, or some other web application.

How you create a database will depend on what type of web hosting plan you have. The type of database you create will depend on the requirements of the script you are installing.

Some scripts will create the database for you, and others will require that you create the database. If your script or project requires you to create a database, then please visit the articles listed for step-by-step instructions.


Connecting Your Script to the Database via phpMyAdmin

After you create the database, you will need to connect the database to your script. Some scripts will configure this for you; others will require that you edit a configuration file.

The following articles may help you connect your script to your database:


Connecting to the Database Remotely

If you are developing your own script or website on your computer, then you may want to use an application on your computer to manage the database. Some web development software, such as Dreamweaver, also have the ability to manage databases remotely. There is a wide variety of software available for this purpose, and they all have varying features and prices. Some are free, and some can be quite expensive. It all depends on the features and functionality you desire.

For this, you will need to do four things. You may refer to the articles provided below for more information.

  1. Create and set up your database (if you have not already).
  2. Download an application you want to use to remotely access the database (if you don't have one already).
  3. Whitelist your IP so that you can access the database remotely.
  4. Configure your software to connect to the database.

This article has useful information on how to connect to your database remotely and by using applications.

To whitelist your IP to connect to your database, you may refer to these articles.


Import and Exporting Database Data

Sometimes you will need to import and export data from a database. This is useful for a number of reasons.

  1. It is one way to create a backup and restore the database
  2. It makes it easy to transfer a database from one place to another.
  3. Some scripts give you a database file that you can import that will set up the database and import required data.

These articles will help you import and export data.


Creating and Restoring Database Backups

It is highly recommended that you make periodic backups of your databases, especially before making any changes to them. Here are guides on how to restore and generate backups of your databases. 


Managing Your Database via phpMyAdmin

Here are some additional tasks you may want or need to do with your database via phpMyAdmin.