MySQL and mSQL

Running mSQL

mSQL is really the only database engine that is “install and go.” In other words, you can install mSQL and start the server right up and be in business. The mSQL server process is called msql2d (for mSQL 1 servers, it is called msqld). This executable and all of the utilities that come with an mSQL distribution can be found in the bin directory. You can start up an mSQL instance simply by issuing the msql2d command with no command line options.

This default implementation will get you only so far. In most cases, you will want to edit a file in the mSQL distribution directory called msql.conf. This configuration file enables mSQL 2 users (it does not exist under mSQL 1) to specify a few common options. Configuring this file is generally necessary only when you are using some precompiled mSQL distribution.

The mSQL daemon process does not fork. This means that running it from the command line will leave the process running in your terminal unless you explicitly press CTRL-C to kill the process or put the process in the background. Under Unix, you can start the mSQL server from the command line in the background using the following command:

msqld2 &

The following script works to start up an mSQL server process at system start-up and to shut it down cleanly on system shutdown:

#!/bin/sh if [ $1 = "start" ]; then if [ -x /usr/local/Hughes/bin/msql2d ]; then su msql -c '/usr/local/Hughes/bin/msql2d &' fi else if [ $1 = "stop" ]; then if [ -x /usr/local/Hughes/bin/msqladmin ]; ...