Blue Reef Technical Support ResellersAbout Blue Reef Consulting, Inc.

EcommerceSearch
Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Specials
Site Map
Support Solutions to help you do business with your Virtual Server.



Virtual Servers Home Page
Virtual Server Support
Virtual Server Addons
Database Solutions
Database Overview
mSQL Overview
mSQL and MS Access
mSQL and W3-msql
mySQL Overview
MySQL and MS AccessMySQL and MS Access
MySQL and ColdFusionMySQL and ColdFusion
PostreSQL Overview
Request help using our Problem Tracking System
Order a Blue Reef Virtual Server now!


mSQL Database

mSQL Overview
mSQL, 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 Server Systems.

Installing mSQL v2.0.x
Please use the steps delimited below as your guideline to install mSQL v2.0.x.
  1. Connect to your Virtual Server using Telnet or SSH and run the mSQL version 2 installation script by typing:

        % vinstall msql

    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.

  2. Version 2.0 of mSQL uses different command-line commands than version 1.0.x of mSQL. The following table summarizes the differences:

        mSQL v1.0.x     mSQL v2.x  
      msql msql2
      msqladmin msql2admin
      msqldump msql2dump
      relshow relshow2

    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:

        source ~/.cshrc

    You only need to do this the first time. When you log in again the changes will be in effect.

  3. Your version 2.0.x databases are stored in your ~/usr/local/Hughes/msqldb directory.
Starting mSQL
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:
    % ps auxww | grep msql
More Information
We've also provided information on configuring the server to automatically process W3-mSQL files.
SEE ALSO:

Access Data Controls

W3-mSQL


PHP Development


Miva/HTMLScript

mSQL User's Guide

mySQL User's Guide

PostgreSQL User's Guide

CGI Scriptorium

Server Add-ons

BOOKS TO HELP YOU:

The Data Webhouse Toolkit
The Data Webhouse Toolkit

$34.99

Amazon.com logo
Search for :
Enter keywords...