Options

 h

Specify a remore hostname or IP address on which the mSQL server is running. The

default is to connect to a server on the localhost using a UNIX domain socket rather than

TCP/IP (which gives better performance)

 f

Specify a non default configuration file to be loaded. The default action is to load the the

standard configuration file located in INST_DIR/msql.conf (usually

/usr/local/Hughes/msql.conf)

 v

Verbose mode

 s

Use the character Char as the separation character. The default is a comma.

 e

Use the specifed Char as the escape character. The default is \

 c

A comma separated list of column names into which the data will be inserted.

Note

 : there can be no spaces in the list.

Description

msqlimport loads a flat ASCII data file into an mSQL database table. The file can be formatted

using any character as the column separator. When passed through msqlimport, each line of the

txt file will be loaded as a row in the database table. The separation character as specified by

the  s flag, will be used to split the line of text into columns. If the data uses a specific

character to escape any occurence of the separation character in the data, the escape character

can be specified with the  e flag and will be removed from the data before it is inserted.

Mini SQL 2.0 (Beta) Run Time Configuration

Introduction

mSQL 1.x offered several configuration options, including such details as the user the server

should run as, the location of the TCP and UNIX sockets for client/server communications, the

location of the database files etc. The problem with configuring mSQL 1.x was that all these

details were hard coded into the software at compile time. Once the software was compiled

and installed you couldn t easily change those settings.

To overcome this problem, mSQL 2.0 utilises an external run time configuration file for

definition of all these values. The file is called 

msql.conf

 and is located in the installation

directory (usually /usr/local/Hughes). An application can choose to use a different

configuration file by calling the new 

msqlLoadConfigFile( )

 API function. All standard mSQL

applications and utilities provide a command line flag, 

 f 

ConfFile

 , that allows you to specify

a non standard configuration file. When an application first calls the mSQL API library, a

check is made to see if a configuration file has been loaded via a call to the

msqlLoadConfigFile( ) function. If no such call has been made, the API library loads the

default config file. Any values that are specified in that file will over ride the normal operating

paramaters used by mSQL.

Structure of the config file

The configuration file is a plain text file organised into sections. The file can contain blank

lines and comments. A comment is a line that begins with the  #  character. Each section of the

configuration file has a section header, which is written as the section name enclosed in square

brackets (for example 

[ general ]

). Currently the only section defined is the 

general

 section

although further sections covering security and access control will be added later.

Configuration values within a section are presented using the config parameter name followed