|
Using MySQL
It is beyond the scope of this site, and my own expertise, to go into details about what a
relational database is, or how to use it.
I will however give you a few pointers to finding software to make administration easier, and
links to further information.
First steps
Assuming that you have a use in mind, the first step is to apply for a MySQL database from
within the member's area of the main Spaceports site. Please note that you must already have
a CGI-BIN account first.
While you are waiting for the details to come through via email, the next step is to decide
whether you will be using Perl CGI or PHP to interact with it.
If you are using Perl, you should download a utility script called MysqlMan from Gossamer-Threads which will allow you to manipulate your
database tables.
If you are using PHP, you should download a script called phpMyAdmin from PHPWizard.Net which will do much the same thing.
You can get by without these, but they do make life a lot easier - especially if the script you
are ultimately going to install expects you to create the tables yourself from the command
prompt.
Armed with the details from your email you shouldn't have too many problems installing these
admin scripts.
Where to go from here
As I have no idea what you are actually going to be using your database for, there is very
little I can do to advise you further.
What I can do is point you towards some sites that may be of use, depending on your specific
needs:-
MySQL.com - One of the many sites offering
MySQL downloads and documentation.
WDVL.com - The Web Developer's Virtual
Library - a huge site with articles on every aspect of Web site development, including
databases.
fatbrain.com - A
wide range of technical books on subjects such as Perl, PHP and MySQL.
FindAScript.com - Freeware and
shareware scripts.
CGI.Resource.com - Perl CGI scripts.
PHP.Resource.com - PHP scripts.
HotScripts.com - A wide range of ASP,
PHP, Perl and Java scripts.
|
