 |
|
 |
| |
Whether you are an experienced web programmer or a
complete novice attempting to provide data
interactivity with your web site, MyQSL is an easy
to use and free database solution that can allow you
to store and configure data to be displayed on your
web site.
Database Server Web Hosting
The best way to create and manage a MySQL database
is to download an open source (free) program called
PhpMyAdmin. PHPMyAdmin allows you to manage all
aspects of both your database structure and data
from one easy to use interface. This tool is
intended to handle the administration of MySQL over
the Web.
Database Server Hosting Information
This tool provides an interface that allows you to
create and drop databases, create, drop, or alter
tables, delete, edit, or add fields, execute any SQL
statement, manage keys on fields, manage privileges,
and import and export data into various formats.
That sounds like a complicated set of activities,
but the easy to use graphical tools make things
quite simple and easy to understand. If you make a
mistake, the software even provides instructions on
where you made your error.
Linux based web hosting
Most Linux based web hosting companies provide
PhpMyAdmin as a standard feature with their
packages. It is also available in a “Windowsâ€
IIS version. If your hosting provider does not
already have this product installed they will often
install it for you, or even allow you to install it
yourself. Setup is quick and easy if you follow the
step-by-step installation documentation.
Step One: Creating your new database
When you log in to your PhpMyAdmin welcome page, the
first step is to enter a name for your new database
in a text box provided. You can name your database
anything that you wish, however if you are creating
the database to use with a script or software
package that you purchased somewhere, the script
provider will often suggest a “preferredâ€
database name. You should always create your
database using the following format:
username_ databasename
Example: myusername_mydatabase
Your complete database name should always begin with
your username followed by an underscore, then
followed by the database name. This allows the
server to know which user is in control of the new
database, and it will also provide permission to
access the database to only specific users. This
also allows different users on the same server to
use the same name for their own database, as you
did, without interfering with your data – that is
helpful if more than one user on your server bought
similar software for their own site. They can then
also use the software providers “preferredâ€
database name.
Step Two: Creating a table for your new database
After you have created a database, the next step is
to create a table, or even multiple tables, for you
to store data. A table is the part of your new
database that actually stores data.
You create a table by selecting the database that
you created from the drop box list of databases.
Once a database is selected a new form appears and
asks for you to create a new table.
Cheap Database Server Hosting
Often your domain name has been registered via a
third-party domain name registration company. When
you move the site, your domain name company remains
the same, and only your Web hosting company changes.
If your domain name originally came with hosting,
you may need to contact your old hosting company to
see if you can separate the hosting package from the
domain name.
The keys to a successful move are planning and
preparation. Before the move you should warn your
users or customers of the forthcoming upgrade.
Prepare a "server down for upgrade" page for your
old site. Note the IP addresses of your new and old
servers; these will come in handy when DNS is still
in flux.
Decide when to upgrade, meaning when your server is
least busy. If you have site statistics, use those
to determine the best time. To reduce down time, it
is best to make the DNS changes several hours before
you actually move the domain. As long as your mail
server is running on the new server, you won't lose
any email messages. If you have a static site, you
can copy over the data before you switch DNS and no
one will ever know your hosting provider changed.
For a dynamic site you can out a skeleton site on
your new server until you make the full move. |
|
 |
|
 |
 |
 |
 | |
