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 to just set it up.
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 discusses those topics more in depth, which also give step-by-step instructions.
Creating a Database
One thing that you may have to do is create a database. This is usually 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, and 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.
- How do I create a MySQL database, a user, and then delete if needed?
- How to create Databases - Plesk 10
Connecting Your Script to the Database
After you create the database, you will need to connect the database to your script. Some scripts will configure this for you, and other scripts will require that you edit a configuration file.
The following articles may help you connect your script to your database:
Managing Your Database in a Web Browser
If you need to make specific changes to your database, such as creating tables, creating, editing or deleting records, changing the database structure, or importing or exporting databases, one way to do it is via a web-based database management software such as phpMyAdmin.
Here are some article on how to manage your database via phpMyAdmin or WebAdmin.
- Accessing Your Database Using phpMyAdmin
- Managing Your Database Using phpMyAdmin
- How to manage databases with the Webadmin - Plesk 10
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:
- Create and setup your database (if you have not already).
- Download an application you want to use to remotely access the database (if you don't have one already).
- Whitelist your IP so that you can access the database remotely.
- Configure your software to connect to the database.
These details and more are in the following articles.
These articles will help you whitelist your IP so you can connect:
- How to Connect to the MySQL Database Remotely
- How to Whitelist Your IP - cPanel
- How to Whitelist Your IP - Windows Shared
- How to Whitelist Your IP - Windows Dedicated
This article has useful information on how to connect to your database remotely:
Import and Exporting Data
Sometimes you will need to import and export data from a database. This is useful for a number of reasons. First, it is one way to backup and restore the database. Second, it makes it easy to transfer a database from one place to another. And some scripts give you a database file that you can import, that will setup the database and import required data.
These articles will help you import and export data, or covers specific scenarios where you might want to do that:
- How to import your MySQL database
- Exporting a MySQL Database via phpMyAdmin
- Copy Entire Database or Rename Database
Here is important information on how to backup your databases. it is highly recommended that you make periodic backups of your databases, especially before making any changes to it.
Other Database Related Tasks
Here are some additional tasks you may want or need to do with your database:
This article does not list all the database articles in our knowledge base. You may want to use the search function if what you want is not listed on this page.