DigitalNuance
Online Support Manual
© 2003 DigitalNuance
- All Rights Reserved.
MySQL
Overview
The MySQL option
in the Control Panel allows the setup of a MySQL database on your site.
Once the database has been installed, there is documentation available within
the MySQL Option for managing the database. This procedure shows you how
to install MySQL and provides a basic overview of the screens you can expect
to see within this option.
Installing
MySQL
How To Install MySQL on Your Site:
Main MySQL
Screen
After your MySQL
database has been installed, accessing the MySQL icon on the Control Panel
will open the database.
The left frame
displays the names of the databases available to you.
The right frame
welcomes you to phpMyAdmin, which is the name of the administrative tool
you are now using to manage your MySQL database.
The link Show
MySQL runtime information displays the following table of statistics about
your database.
The
link Show MySQL system variables displays the following table of statistics
about your database.
The Log Out
link logs you out of the MySQL option.
The phpMyAdmin-Homepage
link opens the phpMyAdmin homepage, an excellent resource of information
related to the use of phpMyAdmin application.
Setting Up
MySQL Databases
When you initially
install MySQL on your site, you essentially create a blank database. In
order to work on your database, you must add tables to it.
How To Add
Tables to Your Database:
Working With
Existing Tables
After you have
added tables to your database, subtle differences to the main database page
will appear on subsequent visits. More options will be available to you,
all of them as a result of the fact that your database now has tables with
which you can work.
For instance,
if you single-click on the plus sign in the left frame beside your database
name, a listing of all of the tables within your database appears.
Tables can be
opened from this listing of tables. Single-click on the table name in the
left frame to open the table in the right frame:
Notice that
the fields and key of your table are listed along with various commands.
These commands allow you to change or drop any field you choose and to perform
other actions.
Underneath the
Documentation link are tools for working with the fields including Inserting
data into the fields.
Other tools
used for working with your database are available from this page. Be sure
to scroll down to see all possible options. Use the Documentation links
for more information.
Run Query
and Query by Example
From the main
database page, you can run queries against your database. When you query
a database, you specify the criteria or description of that query. Then
you send that information to the database and the database returns results
from its data that match the criteria you set. This query box should only
be used if you know how to write queries manually.
The Query By Example link allows you to create a request for information
from your database using a form rather than typing the query from scratch.
The query tool
allows for complex queries against your database.
More Help
for MySQL can be found at:
Web Sites: