or Mini SQL, is a lightweight database engine created to allow fast support
and access of stored data without requiring large amounts of memory. This
database engine provides a powerful capability for accessing databases within
the Virtual Server environment.
The mSQL package includes the powerful database engine, a terminal "monitor"
program, a database admin program, a schema viewer, and a C language API.
The API and the database engine have both been designed to work in a client/server
environment over a TCP/IP network. This makes mSQL the ideal database for
operating within your Virtual Server.
You may use mSQL free of charge insofar as you use mSQL on our Virtual
Installing mSQL v2.0.x
Please use the steps delimited below as your guideline to install mSQL v2.0.x.
- Connect to your Virtual Server using Telnet
or SSH and run the mSQL version 2 installation script by typing:
The mSQL version 2 installation script will perform the following tasks:
- Copy the mSQL v2.0.x files onto your Virtual Server.
- Create a msql.acl
file with some "intelligent" defaults.
- Version 2.0 of mSQL uses different command-line commands than version
1.0.x of mSQL. The following table summarizes the differences:
Some "aliases" will also be created in your ~/.cshrc
file to help you remember. You will need to do the following at the
command prompt before these aliases take affect:
| mSQL v1.0.x
|| mSQL v2.x
You only need to do this the first time. When you log in again the changes
will be in effect.
- Your version 2.0.x databases are stored in your ~/usr/local/Hughes/msqldb
To start the mSQL daemon use the following command:
% daemon -f /usr/local/bin/msql2d
Notice that a similar command has been added to your Rc
file (~/etc/rc) to ensure
that mSQL restarts in case of a host machine reboot. mSQL runs as a daemon
on your Virtual Server.
To check on the status of the mSQL daemon, do the following:
We've also provided information on configuring the server to automatically
process W3-mSQL files.